943,766 Members | Top Members by Rank

Ad:
  • MS SQL Discussion Thread
  • Unsolved
  • Views: 711
  • MS SQL RSS
Mar 4th, 2009
0

How to retireve single column records horizontally with SQL Statement

Expand Post »
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
Reputation Points: 10
Solved Threads: 0
Newbie Poster
Raju5725 is offline Offline
15 posts
since Sep 2006
Mar 5th, 2009
0

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

Take a look at the PIVOT command in Books Online.
Reputation Points: 12
Solved Threads: 6
Junior Poster
Geek-Master is offline Offline
156 posts
since Dec 2004

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MS SQL Forum Timeline: Vietnamese Collation for MS SQL Server 2005?
Next Thread in MS SQL Forum Timeline: SQL record count





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC