Getting First Sunday of a Month.

DECLARE @MonthNumber int = 12 --December

SELECT DATEADD(dd,(DATEDIFF(dd,0,DATEADD(mm,@MonthNumber-1,
DATEADD(yy,DATEDIFF(yy,0,GETDATE()),0)))/7 * 7 )+6,0) AS SUNDAY