This may feel very
simple to many developers and yes it is, but I saw this request somewhere in community
website.So thought of creating a very simple
example.
Here I am using AdventureWorks2014 database, we have table [AdventureWorks2014].[HumanResources].[Employee]
and we will use [HireDate] column. I am adding two new columns named HiredMonthName and HiredMonthNumber to make our example