Getting the name of a month from the month number in SQL Server

I was creating a SmartList for a customer recently and was using the GL11110 and GL11111 views in GP for monthly summaries of P&L accounts, but wanted to show the month names instead of period ID’s to make it a bit more user-friendly. I could have linked to the fiscal period setup table to get the period names, but …

See the rest here:
Getting the name of a month from the month number in SQL Server