SQL: Month name from number

gistfile1.txt

-- Renders out May
Select DateName(month, DateAdd(month, 5, -1))

-- https://msdn.microsoft.com/en-us/library/ms174395.aspx
-- DateName(datepart, date)

-- https://msdn.microsoft.com/en-us/library/ms186819.aspx
-- DateAdd(datepart, number, date)
-- @datepart - the particular part of the date (year, month, etc.,) that will be incremented by an integer
-- @number - the month we are targeting
-- @date - An integer that will return back a particular date

-- @example
-- select DateAdd(month, 5, 0) -1
-- select DateAdd(month, 5, -1)
-- ** both return 1900-05-31 00:00:00.000