SELECT [Firstdatemonth], datename(m,[Firstdatemonth])+' '+cast(datepart(yyyy,[Firstdatemonth]) as varchar) as MonthYear
  FROM [DIM_SEI].[dbo].[UJP_PROD_DLY]
  order by [Firstdatemonth] desc