Can someone explain to me the weekdays? From what is posted above, it doesn't make any sense.

I ask because if you want the First of each month and the day it falls on, I cam up with this. Sorry Jeff, only coded it for a single year.

declare @Year date = getdate();

with TwelveCount(n) as (select n from (values (1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11),(12))dt(n))

select

dateadd(month,n - 1, dateadd(year,datediff(year,0,@Year),0)) FirstOfMonth,

datename(dw,dateadd(month,n - 1, dateadd(year,datediff(year,0,@Year),0))) NameOfDay

from

TwelveCount

order by

dateadd(month,n - 1, dateadd(year,datediff(year,0,@Year),0))