Number of Weeks

Try this one,

---------------------------- Method 1
DECLARE @dt DATETIME, @WeekOfMonth TINYINT
SET @dt = '05/01/2013'
SET @WeekOfMonth = (DAY(@dt) + (DATEPART(dw, DATEADD (MONTH, DATEDIFF (MONTH, 0, @dt), 0)) -1) -1)/7 + 1 
PRINT @WeekOfMonth
----------------------------- Method 2
DECLARE @dt DATETIME, @WeekOfMonth TINYINT
SET @dt = '05/01/2013'
SET @WeekOfMonth = DATEDIFF(week, DATEADD(MONTH, DATEDIFF(MONTH, 0, @dt), 0), @dt) +1
PRINT @WeekOfMonth

---

Regards, RSingh