I only have the month's number and not a full date. I need to use both the month's number and the name in a SSRS parameter. (I sort by the number and display the name. I then filter my dataset on the month number.)
Here's the trick!
SELECT distinct [MonthofYear], DateName(mm,DATEADD(mm,MonthofYear - 1,0)) as MonthName
Order By MonthofYear