It is most likely that scalar function that is causing you issues. Scalar functions can absolutely destroy your server.

If you can post some ddl and sample data I think...

The first step to an answer can be found by reading the first link in my signature.

capn.hector (4/2/2012)

---

Sean Lange (4/2/2012)

---

Koen Verbeeck (4/2/2012)

---

Hi-la-rious!

I do admire your patience.

I would probably already stopped looking at that thread after 3...

capn.hector (4/2/2012)

---

i agree. of course this could also be inside of a cursor all ready...

It really looks like this should be a single update instead of rbar.

There was a spam message in here at one point. After he reported it they took down that message. I...

Ahh I see what you are saying. Chalk up one more reason not to use dirty reads. 😛

Eric M Russell (4/2/2012)

---

jamesforest (3/21/2012)

---

In testing with auto increment I havde noticed the ID field gets incremented even when the insert fails resulting in missing entries. I have tested...

That is ordering by the count of rows. Not sure why 9 was chosen. It could just as easily be count(*).

--edit totally misread this post the first time. 😀

By...

LOL i think it is at 98 now. Waiting for some sort of proof that the OP actually tried something on their own.

I made him read this whole thread. http://www.sqlservercentral.com/Forums/Topic1268991-391-1.aspx :w00t:

Kilroy was here...but I think he left the building. Something about drinking with Elvis or something.

I suggested a couple of options in my previous post. What happened when you tried either of those ideas?

What you have so far is the work that other people have given you. What have YOU tried? There are a couple ways to solve this. Either a self join...