sharonsql2013 (8/25/2016)
I am getting last 4 week numbers in a query - say 31 thru 33.How can I rename 31 as week 1 , 32 as week2 , 33 as week 3 and 334 as week4 so it dynamically keeps changing?
Do your dates wrap at the beginning of your (calendar/fiscal) year? That would cause problems with any calculations. Also, are there actual date fields that can be used instead?
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA