Tuesday 9 April 2013

Concatenate Using FOR XML

SELECT STUFF((
    SELECT ',' AS [text()], CAST(month_name AS NVARCHAR(30)) AS [text()]
    --SELECT *
    FROM dim_date
    WHERE date >= '2013-01-31' AND date <= '2013-12-31' AND date = last_day_of_month
    FOR XML PATH('')
), 1, 1, '') AS months

No comments:

Post a Comment