tag:blogger.com,1999:blog-1661902421469144975.post6839370312046885132..comments2023-06-25T05:27:21.436-07:00Comments on SQL SERVER: Turning Tables into Delimited Textsantoshhttp://www.blogger.com/profile/02203701869158926800noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-1661902421469144975.post-1853616421790127412008-09-05T02:59:00.000-07:002008-09-05T02:59:00.000-07:00Stumbled across this page whilst searching for som...Stumbled across this page whilst searching for something else.<BR/>But a better method for creating a CSV string is something like this.<BR/><BR/>The big advantage is it doesn't need to use a cursor.<BR/><BR/><B><BR/>CREATE FUNCTION udf_Titles_AuthorList (<BR/>@title_id char(6) -- title ID from pubs database<BR/>) RETURNS varchar(max) -- List of authors<BR/><BR/>declare @sList varchar(max)<BR/>set @sList = ''<BR/><BR/>SELECT @sList = @sList + case len(@sList) when 0 then '' else ',' end + au_lname<BR/>FROM pubs..Authors A<BR/>INNER JOIN pubs..titleAuthor ta<BR/>ON A.au_id = ta.au_id<BR/>WHERE ta.title_ID = @Title_ID<BR/>ORDER BY au_lname<BR/><BR/>return @sList<BR/><BR/>end<BR/></B><BR/><BR/>Cheers, AndyUnknownhttps://www.blogger.com/profile/02501757034697849123noreply@blogger.com