sql 2000 concatenate text field by aggregate function
Posted on 2005-05-11
I've got a table that contains email addresses, and I would like to return a single string with all of the email addresses concatenated and separated by commas.
returned query would return:
I really would prefer not to have to make a stored procedure with a cursor, as this list could be exceptionally long and may hog alot of system resources if done that way.
my environment: sql 2000 sp3 running on windows server 2003 sp1