Sql to get the week of year , month of quarter , month of year and quarter of year

Declare

@dd datetime;

Declare
@cntr int;

Set
@cntr=0;

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




Select

 
datediff
(week, dateadd(year, datediff(year, 0, @dd),0), @dd) + 1 weekOfYearCnt,

case
when (datepart(month,@dd))%3=0

then
'3'

else


(

datepart(month,@dd))%3

End
as monthOfQuarterCnt,

datepart
(month,@dd) as monthOfYearCnt,

Cast
(YEAR ( @dd ) as Varchar(4)) +' Q'+Cast((datepart (month,@dd) -1)/3+1 as Varchar(2)) quarterNm,

(
datepart (month,@dd) -1)/3+1 quarterOfYearCnt