hi guys. I'm having problems genera

[jmerencilla]

hi guys. I'm having problems generating the proper t-sql statement that will convert the following result

select name from users
name
-------------
User1
User2
User3
User4

to this result
User1 | User2 | User3 | User4
-----------------------------
User1 User2 User3 User4

pls help.
thanks
jun

 

[clarkin]

Not _entirely_ sure what you are asking here, but I think what's covered in this faq (faq183-2146) will help you out.

Posting code? Wrap it with code tags: [ignore]

[/ignore][code]CodeHere

[ignore][/code][/ignore].

 

[LogicalmanUS]

jmerencilla,

From the way you posed your question, you appear to be asking how to pivot data, but this usually reserved for aggregating data (e.g. summing data from a table - counting the number of instances of a particular value in a column).

Can you give a little bit moore info, please.

Logicalman