That's more like it .

Yup.

Replied to only 3 questions too .

DID YOU ACTUALLY DO THIS?

You realize that it would actually bring you down to about 50 posts sushila, don't you?

No, look books online. It can just execute a normal string just like MyConnection.execute.

I can't test this fromhere but I think that temp table are ONLY listed in tempdb.

You can't. Try exec().

xp_fileexists will not be a set based solution... this could run 10 times slower than the xp_cmdshell version.

Then please post the ddl, the full data dml (enough to make the query work) and we'll see what we can do.

dml = INSERT STATEMENTS

Can or can't Sushila???

Those typos seem to be plaguing you too .

We have 2 straight holidays this time of the year (that happen to fall on friday this year). Then in 2 weeks we're off for a 2 weeks vacations...

If you have several items with the same id with different meaning, you don't have a table and therefore cannot be queried. Try to fix the data first then...

I know... Just throwing ideas around.

Or maybe you need to type a little faster... but that one was a close call.

Talking about call, the week-end is calling here.

L8r guys.

HTH.

C u monday .