ok.. i think i made some improvement here if anybody is still with me.. please find the attachment.. got rid of one cursor.. time reduced from 56sec to 46sec for...

Oh no.. my miscommunication... I have checked your reply BarryYoung, I didn't check GilaMonster's though.. you wanted me to post the code.. that is when I went on to write...

Thank you so much guys. Without checking your replies, I went on to use cursors. The c++ code I posted didn't make sense to me completely and I used an...