It is quiet easy to determine the current week in a year as shown below :
SELECT DATEPART( wk, GETDATE())However, to determine the current week in a month, use this query written by AMB
select datediff(week, convert(varchar(6), getdate(), 112) + '01', getdate()) + 1
