• I note that some form of index on ID should probably be in place here to help both with concurrency and performance.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service