Thank you. I will do some research and see how I can achieve the same results without cursors. Because of tight deadlines I have used cursors in achieving what is...

@jeff Moden -- Thank you for the guidance.

@scottpletcher -- Thank you. I am planning to use the first method.

Thank you. That was meant to be SUM. I will test it and thank you for the link as well.

Thanks. I will try it.

Thanks, to display it only took 4min 11sec to execute. What does over partition by do?