RE: Get next 2 weeks – SQLServerCentral

SSC Guru

Points: 1003894

July 25, 2014 at 11:01 am

sharonsql2013 (7/25/2014)
True, I cannot change the table .
Name is the name of the person , Project is the projectname and all the weeks represent the hours worked on the project.

You haven't answered my previous question. I understand that you can't change the table. Do you understand the normalization process that you'd use if you could? THAT's the key to solving this problem even if it doesn't result in you changing the table.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)