Have you attempted to use the MERGE statement? An example of its features, capabiliies, and use can be found at:
http://www.codeproject.com/KB/database/SQL-2008-Merge-Statement.aspx
If everything seems to be going well, you have obviously overlooked something.
Ron
Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]