I guess I don't understand why you would need to log the insert... if no changes occur at all, the original data is still available in the original table.

He was talking about me blazing through posts and missing stuff...:)

You're a very wise man, Mr. Jones. You sure I can't come to work for you? 😛

Heh... now that there's some funny stuff Mr. Young! 😛

Not trying to take anything away form...

Jack Corbett (7/22/2008)

---

I could make excuse, but stupidity is no excuse (I obviously needed to read up on Order By):D. Here is what I came up with to fix...

Christopher Stobbs (7/22/2008)

---

I've run yours and mine aagainst a 1mil rows and it seems

Results

Mine:

SQL Server Execution Times:

CPU time = 4219 ms, elapsed time = 9937 ms.

Yours:

SQL...

jburkman (7/22/2008)

---

It's why every IT department should have one or two openings permanently available in case someone that's really valuable comes along. Identifying that person can be hard, and to...

When it comes to losing good...

Top work yourself, Chris... it was a real bugger to pull off using 2k code, but you did it!...

Thank...

Perfect and good idea. Thanks for sharing the background of this problem. 🙂

Now that's an interesting use... I normally just use an inner tube sling shot with a foot wide maw on it.

Thanks for the feedback.

We also need to know what you think "full" is... how many bytes is your TempDB?