Hi Drew,

Thanks for that suggestion. For now, I was able to solve it via direct update through recursion option. Now, the performance has dramatically improved and takes less than 10...

Hi Jeff,

Thanks for the response. The Window functions cannot be used in update statements directly, so I used a different technique, whereby I had partitioned the data of unique stocks/dates...