declare @YearMonth varchar(20)
set @YearMonth = '2007.12'
declare @startingDate datetime
set @startingDate = substring(@YearMonth,1,4) + '-01-'+ substring(@YearMonth,6,2)
SELECT Day(DATEADD(dd,-(DATEPART(dw, @startingDate ) - 7),@startingDate )) as FirstSunday ,
DAY(DATEADD(d, -DAY(DATEADD(m,1,@startingDate)),
DATEADD(m,1,@startingDate))) as DayNum
set @YearMonth = '2007.12'
declare @startingDate datetime
set @startingDate = substring(@YearMonth,1,4) + '-01-'+ substring(@YearMonth,6,2)
SELECT Day(DATEADD(dd,-(DATEPART(dw, @startingDate ) - 7),@startingDate )) as FirstSunday ,
DAY(DATEADD(d, -DAY(DATEADD(m,1,@startingDate)),
DATEADD(m,1,@startingDate))) as DayNum