Home Forums SQL Server 2008 T-SQL (SS2K8) Delete and merge duplicate records from joined tables? RE: Delete and merge duplicate records from joined tables?

  • We don't know how your tables or data look like.

    See the first article linked in my signature line and discover how to post effectively and get replies faster.

    Moreover, NOLOCK means "no transactional consitency", it's not a go-faster button. It will return inconsistent data, duplicate data or skip row altogether.

    -- Gianluca Sartori