How to retireve single column records horizontally with SQL Statement

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: 151
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


Views: 507 | Replies: 1
Thread Tools Search this Thread



Tag cloud for MS SQL
"last age autogrowth business connectingtodatabaseinuse count cursor data database dateadd datediff datepart day" dbsize deadlock delete_trigger exploit getdate hack highperformancecomputing hpc hpcserver2008 ibm iis limit live loop maximum microsoft ms mssql multiple multithreading news number password permission position query reporting result security server services sets single source sql sql-injection sqlserver sqlserver2005 subtype supercomputing supertype tables uniqueid update view weekday
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC