Yes that is an even better solution. I also removed EmploymentTypeId from partition by in the sum clause later to get a more appealing increment in Grp. Thanx for your...

Excellent! Ive never seen sum() used with over (... order by ) this way before so I learned something new today! 🙂 Thankyou!

(This was an excerpt from a fact-table in...