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

Can we use custom code in ssrs?

1057

What is sql injection? How to protect against sql injection attack?

941

How to create stored procedures with parameters in ms sql server?

991

How to add an address record into adventureworkslt?

932

How to read data in a table with "select" statements?

918

Can a table have 2 foreign keys?

856

What is nolock?

927

How to change parameter value inside the report?

153

Define Business Edition in SQL Azure?

100

what changed between the previous version of sql server and the current version? : Sql server database administration

956

How to loop through result set objects using odbc_fetch_row()?

919

How to create a dynamic cursor with the dynamic option?

969

What is report subscription?

117

What are the different methods available under sqlcommand class to access the data?

1058

What do you mean by subquery?

1021