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 differences between ms sql server & oracle?

1036

What is the maximum size of sql server database?

988

What are indexes in ms sql server?

1037

What's new in sql management studio for sql server? : sql server management studio

1052

What is reference section?

985

What is the difference between ddl and dml?

1034

What is the tcp/ip port on which sql server runs?

1130

How does index makes search faster?

958

What are the tables in sql?

1072

What is data modification?

943

How do you know if sql server is running on your local system?

1022

What happens if time-only values are provided as date and time literals?

994

How we create SQL Server 2005 Reporting Services ? Give me Sample

1975

Where are stored procedures in sql server?

1050

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

1372