How to find seconday thusday of month..

This return for current month-

SELECT

CONVERT(CHAR(10),

DATEADD(wk,1,(CURRENT_TIMESTAMP -

Day(CURRENT_TIMESTAMP)+1)+(5-DATEPART(dw,(CURRENT_TIMESTAMP -

Day(CURRENT_TIMESTAMP)+1)))),

121)

Hello,

( monthdate date not null primary key )

insert

into #monthdates ( monthdate )

values

( '2015-11-05' )

, ( '2014-11-06' )

, ( '2013-11-07' )

select monthdate as first_thursday_of_month

, dateadd(day

, ( ( 17 - datepart(dw,monthdate) ) % 7 ) + 7

, monthdate

) as second_thursday_of_month

from #monthdates

drop table #monthdates

declare @weekStart datetime,@weekEnd datetime,@yearNo char(4),@weekNo int
select @yearNo=cast(datepart(yy,GETDATE()) as char(4))
select @weekNo={fn week(GETDATE())}

select @weekStart=dateadd(wk,Datediff(wk,6,'1/1/'+@yearNo)+(@weekNo-1),6)

select @weekEnd=dateAdd(wk,datediff(wk,5,'1/1/'+@yearNo)+(@weekNo-1),5)

print @weekStart
print @weekEnd