try using Pivot. for details follow the link http://msdn.microsoft.com/en-

there is a table having two columns no and name
and the data is
1 A
2 B
3 C

write a query that will result a horizontal output
A,B,C

Question Posted / miller

Answer Posted / miller

try using Pivot. for details follow the link
http://msdn.microsoft.com/en-us/library/ms177410.aspx link

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the tool windows in sql server management studio? : sql server management studio

1060

Explain unique key in sql server?

1003

Determine how to use the inserted and deleted pseudo tables?

978

How can windows applications connect to sql servers via odbc?

1116

Is oracle faster than sql server?

941

How to optimize stored procedure optimization?

886

Write a SQL queries on Self Join and Inner Join.

1034

You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?

310

What objects does the fn_my_permissions function reports on? : sql server security

1027

What are the general features of sql server management studio? : sql server management studio

1067

what are user defined datatypes and when you should go for them? : Sql server database administration

1000

Explain primary key in sql server?

1006

How to select some specific columns from a table in a query in ms sql server?

993

How to download and install microsoft sql server management studio express?

1026

Is t sql the same as sql server?

955