Subject | Stored procedure to return multiple rows in a single string |
---|---|
Author | Zd |
Post date | 2008-02-26T21:50:11Z |
Hi everyone!
Sasha told me in our previous conversation that it would be possible to write a stored procedure that joins strings from multiple table rows into a list and returns it as a string.
So
row1
row2
row3
would look like
"row1, row2, row3" in a single string. The stored procedure would be called in a main select query.
Unfortunately I'm not a master of stored procedures, and I can't seem to find enough info on Google on how to create such a listing procedure.
Could someone point me in the right direction with an example?
Thanks!
-Zd
[Non-text portions of this message have been removed]
Sasha told me in our previous conversation that it would be possible to write a stored procedure that joins strings from multiple table rows into a list and returns it as a string.
So
row1
row2
row3
would look like
"row1, row2, row3" in a single string. The stored procedure would be called in a main select query.
Unfortunately I'm not a master of stored procedures, and I can't seem to find enough info on Google on how to create such a listing procedure.
Could someone point me in the right direction with an example?
Thanks!
-Zd
[Non-text portions of this message have been removed]