Like a...

"Steping" through rows with a CTE can be done... but it will be much slower because recurrsion is worse than a simple cursor or while loop... and we both know...

GilaMonster (12/27/2008)

---

He's a repeat offender who just doesn't seem to get it. I have several unpleasant memories of that...

Oh yeah... I knew I was forgetting something...

You're trying to update the whole table, right? Instead of pussy footing around with row locks changing to page lock changing...

Thanks, guys. :blush: It's amazing to me how often a problem can be resolved by the "running total" method.

Heh... let's put it in terms of common sense... whether it's legal or not, would YOU want you SSN in clear text along with other personal and financial information on...

BWAAA-HAAA! Excellent candidate for this year's SQL Darwin award...

http://www.sqlservercentral.com/Forums/Topic478330-8-1.aspx#BM480712

Scroll up from that post to see the hell he caused a bunch of people because he thought Sybase and SQL...

I believe that I'd post that exact same thing on Simple Talk and let Phil and Robyn have a crack at it... they're the ones that wrote the method to...

Jay Sapani (12/27/2008)

---

I Have A Simple Update Query But It Takes A Lot Of Time,How Can I Reduce Its Time ?

I Have A Table With 10 Lakh Records.

I Want To...

Yep... and we don't need a WHILE loop, either (it would be just as slow)...

First things first... here's the...

Dugi (12/27/2008)

---

interesting variable value ...at first when I saw your sample data it shows me the logic that max_value - min_value = allowed_value but the last record doesn't have this...

Nah... the logic is pretty simple if you look at it right... the 23 is not being split by Min value... it's being split by the difference between the Min...

Thanks for the feedback, Jeanangeo. Glad you got it solved.

Anyone that thinks...

Grant Fritchey (12/27/2008)

---

Don't be too sure about that. I remember interviewing this guy once who never got an answer wrong. He could talk all day long about the databases. We...