comma delimited string in exec sql code example
Example: sql server results to comma delimited string
DECLARE @csv VARCHAR(MAX)
SELECT @csv = COALESCE(@csv + ',' ,'') + book_title from Test.dbo.Books where book_id IN ( 101, 102, 103);
SELECT @csv
Output
Head First SQL, SQL Puzzler, T-SQL Fundamentals