I want the start of the week from 04-12-2015 thru 4-18-2015. (Sat thru Sun)

That helps..Thanks a lot

Changed the signed from < to > which was the requirement though. ANd now it pulled up quick

No worries, I had to make changes both ways , Proc n table which I was missing.

Well this helped

http://dbaspot.com/ms-sqlserver/371877-how-allow-apostrophes-string-parameters.html

Great I see it.

Guess , I should ask this in some other forum as I am trying to do it in SSRS Hyperlink where its not taking this name as...

I see...

Create Table ##DateTable

(

Lastweek Int

,Lastweek1 Int

,Lastweek2 Int

)

Insert into ##DateTable(Lastweek,Lastweek1,Lastweek2)

Values (DATEPART(WW,GETDATE()) - 1 ,DATEPART(WW,GETDATE()) - 2, DATEPART(WW,GETDATE()) - 3 )

Select * from ##DateTable

Thanks

North America , AB ,BC is the expected output

Yeah, it was tricky. So, I tweaked the Join condition. Saved !

Any other ideas?

This link helped

https://social.msdn.microsoft.com/forums/sqlserver/en-US/bfd922e5-8bf7-42ab-becb-d3fc4faf44b5/lastname-firstname-switch

Nevermind, Was able to figure out - It should be Nothing.

Works! But Can you explain what CTE 2 does ?

Well, I don't have permissions to do something like this, Is there a way I can pass multiple table names like in the first query...

No there no parameter set up.

It gives everything in one chart.so I cannot use the parameter expression.