Thank you so much, Luis C - Works perfectly.

Thank you for replying.

Output should be

MonthWeekStatus

2013/012013 Week 01-1

2013/012013 Week 02-1

2013/012013 Week 03-1

2013/012013 Week 040

2013/012013 Week 05-1

2013/022013 Week 06-1

2013/022013 Week 07-1

2013/022013 Week 08-1

2013/022013 Week 090

2013/032013 Week 100

2013/032013 Week 110

2013/032013 Week 120

2013/032013...

Thank you so much for simplifying that Code.

Its works perfectly except for

'2013 Week 52' to '2014 Week 07' - All should be -2 based on my rules above....

Thank you the most amazing, incredible SQL query. I cannot begin to describe how much this query assisted me. I have one request though please.

I now need to run a...