Try this it might help you
Select left(DateName( month , DateAdd(MONTH , [Month]* , 0 ) - 1 ),3)+ '-' + substring(CAST([year]* as CHAR(4)), 3, 2) AS Month,Dealer + '-' + Dealer_Code + '-' + City as Dealer,Points as Service point ,manth ,Month from MyTable
[Month]* and [year]* is the column name of the table MyTable
Keep smiling :):):) Happy coding :)