SELECT DATENAME(MONTH, DATEADD(MONTH, monthid - 1, CAST('2014-01-01' AS DATETIME))) FROM table1
DateTimeFormatInfo m = new DateTimeFormatInfo(); string Month=m.GetMonthName(int Month_No)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)