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

9 Answers
12235 Views
tdfc, vsworx, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the temp table?

975

write an SQL query to list the employees who joined in the month of January?

1737

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

997

Tell about MOM Tool(Microsoft Operator Manager)?

1959

What's the information that can be stored inside a bit column?

1069

Explain what you mean by 3 tier architecture.

1125

How to list all tables in the database using odbc_tables()?

1116

What is stored in the mssqlsystemresource database? : sql server database administration

1081

What is cursor in ms sql server?

1202

Do you know what is rank function?

1126

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1110

What is a join in sql?

1155

Where is trigger in sql server?

1104

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

1200

What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

1220