mmmm not bad teacher

that is if i want to update the records in my real table, but what if i have to add...

well yes i get the point, but i have to use a cursor to scan each line in the temp table then create or update records in real tables...

so....

that's good to know!

but then again (excuse my ignorance :blush ... what do you mean by SET based UPDATES ?

I'm probably doing it without...

ok great!

tx again

yes but i don't want to use DTS or SSIS

Ok, tx!

But what if the field i want to get the value is not an identity?

is

Select

max(iRecipientId)