Declare @result VARCHAR(8000) SELECT @result = '' SELECT @result += temp.temp FROM ( SELECT DISTINCT ('Posted Date' + CAST(POSTED_DATE as char) + ',') as temp FROM [LACDC].[dbo].[PS_CDC_JRNL_LSR_VW] where JOURNAL_ID = @ID and JOURNAL_DATE = @Date ) AS temp