I had to make a bigger table to get some timing stats.... also means I had to convert both scripts to use a Tally table and make a large enough...

I kinda thought that, as well. Thanks, Matt. It'll be interesting to see what you come up with...

...

Thanks for the feedback and glad it suits your needs... now you know why I kept asking for more detail...

Folks, this is a perfect example of why I wrote the...

I don't know the differences between a Blackberry and a SmartPhone because I haven't had to carry either.

I with Johan, though... if you're gonna put a ball and chain on...

Never mind... I just had another cup of coffee...

Here's the untested answer...

--===== If the temp table exists, drop it

IF OBJECT_ID('TempDB..#tt_Mum','U') IS NOT NULL

...

ebuss_2004 (2/17/2008)

---

How Can I accomplish this without using CURSOR?? This is running extreemly slow since the t_ATM table has over a million records. Appreciate any help!

DECLARE

...

Oh yeah... for those in the know... yes, I used a triangular join in a correlated sub-query... performance will be terrible compared to the "UPDATE" method I wrote about, but...

Ta-da! See how much easier that is for folks to work with. Thanks for taking the time to help us help you...

Here's the solution including the test setup...

Now, we're cookin'... I'll be right back... 😉

Ok... here's some extraordinary proof that supports what Itzek said...

First, I made a table in a nice safe place... TempDB... couldn't use a actual temp table because I wanted...

Marios Philippopoulos (2/17/2008)

---

From "INSIDE MICROSOFT SQL SERVER 2005 - T-SQL QUERYING" by Itzik Ben-Gan, Solid Quality Learning, pg 429:

Another aspect of the IDENTITY property that can be considered a limitation...

Yeaah... I'm going to spend my time reformatting your data...

This is what your text file looks like...

SalesDate StockCode costPrice SalesPrice SalesAmount Total ----------------------- -------------------------------------------------- ----------- ----------- ----------- ----------- 2008-01-01 00:00:00...

How does one determine if a page split has occured during an update?

But, you didn't read my previous reply... you've...