Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by David Poole Need Help with insert and update using sql server 2005 RE: Need Help with insert and update using sql server 2005

  • August 11, 2010 at 5:33 pm

    #1205768

    hemagkv (8/11/2010)

    i get an error at from with the update statment.

    can't we do this with a single query? stored procedure?

    You can do this with a single query only if you're on SQL 2008. Then you can use the MERGE statement.

    Until then, you need to do the UPDATE, followed by the INSERT, to do this. Lutz gave a great example; use it.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2