Repair duplicate names due to deleted records; add “Deleted: <timestamp>” - Repair duplicate names due to deleted records; add “Deleted: <timestamp>” - Saperion ECM - Saperion - Saperion-ECM/Saperion/Foundation-EP7/Saperion-Update-Guide/Data-integrity-test-scripts/Scripts-for-MS-SQL-Server/Repair-duplicate-names-due-to-deleted-records-add-Deleted-timestamp - Foundation EP7 - Foundation EP7

UPDATE [XSGRP] SET [FULLNAME] = [FULLNAME] + ', deleted: ' + CONVERT(varchar,[SYSTIMESTAMP])
WHERE [SYSINDEXSTATE] > 0 AND [FULLNAME] IN (SELECT [FULLNAME] FROM [XSGRP] GROUP BY
[FULLNAME], [SYSCLIENT] HAVING COUNT(*) > 1 )
UPDATE [XSUSR] SET [DISPLAYNAME] = [DISPLAYNAME] + ', deleted: ' +
CONVERT(varchar,[SYSTIMESTAMP]) WHERE [SYSINDEXSTATE] > 0 AND [DISPLAYNAME] IN (SELECT
[DISPLAYNAME] FROM [XSUSR] GROUP BY [DISPLAYNAME], [SYSCLIENT] HAVING COUNT(*) > 1 )
UPDATE [XSUSR] SET [FULLNAME] = [FULLNAME] + ', deleted: ' + CONVERT(varchar,[SYSTIMESTAMP])
WHERE [SYSINDEXSTATE] > 0 AND [FULLNAME] IN (SELECT [FULLNAME] FROM [XSUSR] GROUP BY
[FULLNAME], [SYSCLIENT] HAVING COUNT(*) > 1 )