MS SQL RSS MS SQL RSS

How to retireve single column records horizontally with SQL Statement

Please support our MS SQL advertiser: Intel Parallel Studio Home
Reply

•
•
Join Date: Sep 2006
Posts: 15
Reputation: Raju5725 is an unknown quantity at this point 
Solved Threads: 0
Raju5725 Raju5725 is offline Offline
Newbie Poster

How to retireve single column records horizontally with SQL Statement

 
0
  #1
Mar 4th, 2009
i have only one coloumn in a table i want to dispaly all the datas in a row.Name of the table is student which contains only one coloumns slno
Student
Slno
1
2
3
4
5
I want to display them as
slno 1 2 3 4 5

Thanks in advance
Raju
Reply With Quote Quick reply to this message  
•
•
Join Date: Dec 2004
Posts: 149
Reputation: Geek-Master is an unknown quantity at this point 
Solved Threads: 6
Geek-Master's Avatar
Geek-Master Geek-Master is offline Offline
Junior Poster

Re: How to retireve single column records horizontally with SQL Statement

 
0
  #2
Mar 5th, 2009
Take a look at the PIVOT command in Books Online.
If in doubt, reach into the trash can and remove the user guide.
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread is more than three months old.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Other Threads in the MS SQL Forum
Thread Tools Search this Thread



connectingtodatabaseinuse count cursor database datepart deadlock delete_trigger highperformancecomputing hpc hpcserver2008 ibm iis loop maximum microsoft ms mssql multithreading news number permission query result server sets sql sqlserver sqlserver2005 supercomputing uniqueid update view
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC