Heh... sorry about that... saw the recent post and didn't check the dates on the history.

You feel "bashed" by anything on this thread?   Most folks express some urgency when they post a question and your's is likely interesting... All...

He's gotta load all the data into a staging table, anyway... why not use it?  End result will be the same except the switch will be much, much faster...

You bet... thanks, for the feedback.

I'm not sure you're telling the whole story... if the 800 million rows is a staging table, of sorts, why not just add a "present" column to it and update...

Johnathan's code is good... but check the performance and resource usage when compared to the numbers-table solution that Remi squeezed off...

Hey Remi... nice loop on the table creation

Just curious... why didn't you just try it?

Well, what say thee, James... I see at least 3 people that really wanna help you fix this... all you need to do is post the offending code. 

Uh, Terry... if you think that's bad, wait until the world of hurt you run across when you try to do something a bit sophisticated in ISQL... ISQL is severly...

Why?  The path should take care of things just fine.

Why so hell-bent on using table variables?  They live in the exact same place that Temp Tables do and have the disadvantage of not using statistics.  Use the Temp Table...

I guess I'm a lucky Man... I don't have that type of problem at work and this is the 3rd company in a row I've worked for that actually embraces...

I agree with both Andy and Steve (thanks for the feedback, guys).  A blog at work could certainly be useful to the company as well as allowing the individual to...

Heh!  More than 6000 posts and you still haven't got it down to {Ctrl-A}{Ctrl-C} before you hit the Submit button?

Heh... doesn't matter, Rudy... folks can always buy hardware to make up for the lack of knowledge