Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Return result set in formated string

Author  Topic 

dadunn
Yak Posting Veteran

67 Posts

Posted - 2001-07-19 : 15:50:33
I am working on a notifcation routine that will send a e-mail to several different people when data is imported into the SQL server from the EDI system.

I have a table with a user_name column. Is there any function that allows you to return all selected rows as a string? Something like

user1;user2;user3

I know I can build it with a cursor, but.....

What would nr say if I resorted to a cursor when I didn't have to.

   

- Advertisement -