Subject help on a stored proc
Author zifnabbe

In another thread I received the advice of programming something in a
stored proc. My stored proc is rather limited. Can somebody give me
some hints? I've searched several groups and faq lists, but can't
find help, although it should rather be simply, I guess:

I need to store a record into a table, but first before I insert it,
I've to check if it exists, if it doesn't I've to insert it in the
table, if it exists I've to update the existing record.

And if possible, Is there a way to get information on which records
were inserted/updated or failed (because of data not correct?)

Thanks in advance,