Thank you all for your replies, next time I'll try to write more properly, sorry!

Yes, I don't care which rows are deleted, I just want to keep one, no matter...

Oh, i think i misunderstood the delete part :blush:

Ok the code works, but I don't want to delete records from the source table :ermm:

Do you suggest that I copy all the a temp table , delete from the...

Hello

I've tried what you suggested, it works, only if the following statement always returns a value

SELECT new_model FROM #product WHERE model = old_model

But in the case where old models don't...

This is exactly the case! I will try that

Thank you loads!! 🙂

Exactly! how can i do each statement in a transaction?

sorry, i replied while u where also posting 😉

Here is another example with more realistic tables and code:

table SOURCE contains clients, with the product they hold (MODEL_NO)

since they manually enter...

yes, this is what i was doing.

but as i explained, if i have a unique index error, the transaction is rolled back, and the update doesnt take place.

While if i...

Actually the update statement is a bit more complicated.

Let's say that i get the phone number from another embedded select (that's why i put values likes XXX and YYY).

The purpose...

well actually, maybe if i give an example it will be clearer: 🙂

I have a clients table where each client has one product.

But sometimes, the product code was entered manually...

If Andras Belokosztolszki from Red Gate says it's ok, then am ok!

Tx!!:cool:

:Whistling: yes, I will correct the looks 😉

and yes, recursive trigger option is set off!

tx again!!!

well actually this query is automatically generated by a software, and i ca't really can customize everything in it.

So i was wondering why there is a difference for the...

Thx all for the tips!

osql works great!

well, seems that the error is due to a wrong export path

D:\backup does not exist , didn't notice that! But i wish i...