Sql to getthe week of a month and week of a quarter

Declare

@dd datetime;

Declare
@cntr int;

Set
@cntr=0;

Select
@dd=DATEADD (dd ,@cntr , '2013-08-11' )

Select
 
(
DAY( @dd) +(DATEPART(dw, DATEADD (MONTH, DATEDIFF (MONTH, 0, @dd), 0))-1)-1)/7 +1 as weekOfMonthCnt,

DATEDIFF
(WEEK, DATEADD(QUARTER, DATEDIFF(QUARTER, 0,@dd), 0), @dd) weekOfQuarterCnt