Heh... to be clear, I've never written a cursor except to show how slow they...

Sorry... didn't know that...

Still, I posted some questions on that other thread because I need more info to help you. Any answers on those?

Thank you for the feedback 🙂

Like I said, the data needs to be made more consistent... and the code below does that. About all you need to do is change the path to the...

Thanks... that's a lot better.

Suggestion on using...

shalini_pdi (5/5/2008)

---

I have followed the same procedure as u have mentioned. Its working fine. If i execute the code more than once i got the error as There...

GSquared (5/5/2008)

---

Another excellent article on tally/numbers tables is at:

http://www.simple-talk.com/sql/t-sql-programming/the-helper-table-workbench/

by the lovely Robyn Page and the hillarious Phil Factor (I hope I didn't get that backwards 🙂 ).

The only thing I...

Two things... first, they consume more resources and locks than necessary... those can be mostly overcome by...

Thanks for the feedback, Sergey!

Keith DuAime (5/5/2008)

---

That article, great by the way, is where I got the idea from. I realized I forgot the with index hint and then also added option(maxdop 1) and...

Thanks, Gail... That's one of the ones I was trying to find... I can't find the other one that explains the "why"...

Maybe I've not had enough coffee... or maybe just too much scotch.

How do you check the production execution plan without getting QA involved, Barry?

john pan (5/4/2008)

---

thanks for your replies -

what do you mean by recompiling for each row updated?

Are you saying that the query plan is being re-evaluated for each time a row...

Do you have the original file? SOmeone obviously tried to change the first one... even a computer couldn't screw things up that badly... takes a human beinging to mess...

Thank you for the feedback... but we'd all be interestd in what you actually meant...