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