If you are the DBA/Senior Developer, they should have no problem with with the memory on your desktop... all of our developers have at least 1 gig and most have...

I believe NUMERIC(10,0) will allow for 9,999,999,999, not just 1,000,000...

Heh... gotta love Microsoft... we're at SP2a and they still didn't get it right... thanks for the feedback and thanks for reporting it to MS.

I got no errors when running what you posted.

What do you get for this?

SELECT TOP 75 PERCENT intValue

  FROM #tmp

ORDER BY intValue ASC

If you can pack it in, 3 gig would be nice... if you get to the swap file, it's too late.

Dang!!! Spot on Michael... great minds think alike.

I'm trying to mello out in my old age... wasn't going to ask about why anyone would want to do something so insane......

Actually, it's a long but fairly simple crosstab.  The big performance killers are whereever you have the unqualified correlation of...

a.order_id <> b.order_id

That's IF it were to ever be executed......

One other thing... Centrino's aren't real good for 2005 (or even 2000).  There are a couple of other processors that pretty much suck, as well, but I can't remember their...

Heh... now you know why I always wait for a couple of service packs to come out before making a switch...

I'm thinking...

There's gotta be a thousand posts on this web site for "crosstab" and "transpose" and "pivot".  Do a search on it and I'm sure you'll find one that fits.  Also,...

Thanks for the feedback, Therion... it means a lot to us that someone is actually looking at the answers.  Appreciate it much!

Looks more like homework to me...

Putting the Recovery Mode to Simple sets the 'trunc. log on chkpt.' to true automatically.  Your problem is the log... your Insert/Select is still logged despite the SIMPLE setting you...

p.p.s.  Why the hell are you using DTS for such a simple BULK INSERT task, anyway... you like "slow" or something