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 is stored in the mssqlsystemresource database? : sql server database administration

1035

How can i Relate Tables in SSIS

1081

What is read committed?

1095

What is difference statement and preparedstatement?

986

Explain triggers in sql?

957

Explain the usage of floor function in sql server.

968

Why we need sql server?

972

What is cross join in sql server joins?

1146

what is the information that can be stored inside a bit column? : Sql server database administration

969

What were the latest updates to SQL Azure service?

111

What is 2nf example?

999

What are different types of statement?

1019

Is the log file is a part of file group?

1041

Explain features of analysis services?

1004

Is candidate a key?

955