Very Simple Query to Print All the Months

just run the below query to print all the months from January to December(without using loop)
code:

;WITH santosh
AS
(
SELECT 1 AS [Month]
UNION ALL
SELECT [Month] +1 FROM santosh WHERE [Month]<12
)
SELECT [Month] [Month], datename(month,dateadd(month, [Month] - 1, 0)) [Month Name] FROM santosh
GO

No comments:

Post a Comment