Thanks for your quick response. Yes, the calling stored procedure has to insert rows in another table based on the passed in parameter if that table does not have...

No, I cannot use function becuse if I understood correctly I cannot have Insert/update/Deletes in a scalar function OR may be in any function???

As this article says many programmers do check for the existence of the record before inserting is true but its done by only those sql programmers either who are lazy...

Thanks again, I will definitely check out the Merge command. and will come back if I need any help. 🙂

Thanks, at least I got the clue now. I can use the Merge Replication. I will read upon it and lets what it can do for me.

Also, we...

Oops! My bad! Didn't realize that its went under SQL 2000. This was my first post and apologize for the misplace. Is there any way to move...