Originally posted by slimdave
Another approach would be to code it as a bulk operation, performing an insert, catching exceptions, and updating based on those exceptions.
If bulk operations can be done wass the need of "catching exceptions" in some other/temp table?

can be done in jus 2 statements Insert(Not exists clause) & Update(Exists clause).


Abhay.