Yup nice catch.

Easy fix then :

Truncate table TableName

Other than the ones you named, I'd also look into the disadvantages of using xml at all... you'll find plenty more arguments there.

Hey I got to have something strong to hold that head .

And yes that's the 2nd time she calls you that.

That's why I compliment myself... don't have to wait for others to say them.

That's why the design should be normalized .

What's that supposed to mean David?

CASE WHEN Date2 <= @DateEnd THEN Payment2 ELSE NULL END

Dumb @$$.. I thaught you had 7 tables instead of 5...

can you post the ddl and dml statements to create the tables and insert this data?... or you can also...

Maybe you should try restating your problem with more details... there's no obvious solution here.

I don't know about the sequence... but might I suggest you test this with a smaller load (say 2M / 0.75M rows) to make sure that it works, and that...

Backstreet Boys

... not that actually like them .

Oops, right answer to wrong question :

SELECT ISNULL(Test1.ID, Test2.ID) as IDs

FROM Test1 FULL OUTER JOIN Test2 ON Test1.ID = Test2.ID

WHERE Test2.ID IS NULL or Test1.ID is null

It can be done in a DTS activeX script :

This code would need to be adapted but you'll get the idea.  This loops in all the user tables, gets...

Select Col from dbo.test1 T1 where not exists (Select * from dbo.Test2 T2 where T1.Col = T2.Col)

As the BBS say : Never Gone .