Month Names

WITH DATES AS
(
    SELECT CAST('1/1/2000' AS DATETIME) [d]
         , 1 [c]
    UNION ALL
    SELECT DATEADD(month, 1, d)
         , c + 1
    FROM DATES
    WHERE c < 12
)
SELECT d [date]
     , DATENAME(month, d) [month]
FROM DATES
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s