Date conversion, etc

To be continued...

How to get the month name for a specific month number

Select DateName( month , DateAdd( month , @MonthNumber , -1 ))