Home Forums SQL Server 2008 SQL Server 2008 - General if where on update doesn't match do an insert RE: if where on update doesn't match do an insert

  • July 23, 2014 at 10:57 am

    #1731851

    Like Jack I would consider the merge statement. One caveat is to be careful around filtered indexes.

    Here is more info on that bug http://sqlblog.com/blogs/paul_white/archive/2012/12/09/merge-bug-with-filtered-indexes.aspx.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events