Is this running on a 386???

Is there a trigger in the table. Are there any indexes on those tables?

Just curious... what did Noeld do today? It's not mentioned in the thread (unless I missed it, again ).

Finally a thread started from you... maybe next time you'll have to courage to ask a question (now I understand more why you're afraid).

Congrats on the thread.

yeah yeah I'm really...

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...