Thanks all !!

SELECT

@ThisDate,

DATEADD(ww,-8,@ThisDate),

DATEADD(ww,DATEDIFF(ww,0,ISNULL(@ThisDate,GETDATE())) - 8,4),

DATEADD(ww,DATEDIFF(ww,'19000101',ISNULL(@ThisDate,GETDATE())) - 8, DATEADD(dd, 4, '19000101'));

So I understood the first part and...

I am not able to narrow the result for last 8 weeks using current date..

This gives the perfect result. how can I store the result set in a temp table. I want to store these values in temp table and use that temp table...

yes it needs to be pivoted and show the dates in reverse order.. I mean beginning from the first month and first friday..