SQL SERVER – Creating Comma Separate Values List from Table – UDF – SP | Journey to SQL Authority with Pinal Dave

Following script will create common separate values (CSV) or common separate list from tables. convert list to table. Following script is written for SQL SERVER 2005. It will also work well with very big TEXT field. If you want to use this on SQL SERVER 2000 replace VARCHAR(MAX) with VARCHAR(8000) or any other varchar limit.… Continue Reading...

Source: SQL SERVER – Creating Comma Separate Values List from Table – UDF – SP | Journey to SQL Authority with Pinal Dave