• Glad to Help,

    You could add a where clause to check the NodePath with the FullPath column eg

    WHERE hr.FullPath!=NodePath

    Which should reduce the dataset, and save you having unnecessary updates.

    _________________________________________________________________________
    SSC Guide to Posting and Best Practices