Posted by candide_sh on 10/30/07 18:08

Hello,

can I do this via SQL:

example: tbltest has 5 rows:

col1
===
A
C
F
M
R

What I want is this:

result:
===============
A, C, F, M, R

Do I really have to go through the rows per SP? I could do this:

SELECT UDF(col1)
FROM tbltest

Ain't there a more simple way, maybe theres a T-SQL-command ?

thx
candide_sh

• Next in forum: Re: get some rows into one column
• Prev in forum: Re: Error message on using union statement with order by using reserved words
• Thread view: get some rows into one column

[Reply to this message]