SQL Displaying of Data Horizontally

[ja01]

Using MS SQL Server 2005, I want to display instances of data horizontally. For example if I choose
select membid, membtype from membership where membid = '0001' I would get
0001 c2 (0001=membid, c2=membtype)
0001 c3 (0001=membid, c3=membtype)

Is there a way to set up an sql statement to display the data to read like this?
0001 c2 c3

 

[AlexCuse]

have a look at this:

http://www.tek-tips.com/faqs.cfm?fid=5269

or this:

http://www.tek-tips.com/faqs.cfm?fid=5278

hope it helps,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[AlexCuse]

Hey I just realized that the code in the first one does not parse correctly. So take a look at this thread:

http://www.tek-tips.com/viewthread.cfm?qid=1351652&page=7

Hope it helps,

Alex

Ignorance of certain subjects is a great part of wisdom