SELECT DateName(MONTH,ModifiedDate)AS 'Month', CName FROM TempData
SELECT ID, MONTH(DateOfBirth), Name FROM MyTable
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)