It is quiet easy to determine the current week in a year as shown below :
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