Victoria shows us how to Get the name of a month from the month number in SQL Server. This is very handing for reporting from Dynamics GP.
Getting the name of a month from the month number in SQL Server | Victoria Yudin
SQL & DataInstall, Upgrade & Admin
Archived post from 2011. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.