IF OBJECT_ID('XS_MIGRATION_CHECK', 'U') IS NULL CREATE TABLE [XS_MIGRATION_CHECK]
( [NAME] varchar(128), [TENANT] int, [ERROR] varchar(128) )
GO
DELETE [XS_MIGRATION_CHECK]
INSERT INTO XS_MIGRATION_CHECK ( NAME, TENANT, ERROR ) SELECT [FULLNAME],
[SYSCLIENT], 'DUPLICATE FULLNAME IN XSUSR' FROM [XSUSR] GROUP BY [FULLNAME], [SYSCLIENT] HAVING COUNT(*) > 1
INSERT INTO XS_MIGRATION_CHECK ( NAME, TENANT, ERROR ) SELECT [ID], MAX([SYSCLIENT]),
'DUPLICATE ID IN XSUSR' FROM [XSUSR] GROUP BY [ID] HAVING COUNT([ID]) > 1
INSERT INTO XS_MIGRATION_CHECK ( NAME, TENANT, ERROR ) SELECT [FULLNAME], [SYSCLIENT],
'DUPLICATE FULLNAME IN XSGRP' FROM [XSGRP] GROUP BY [FULLNAME], [SYSCLIENT] HAVING COUNT(*) > 1
INSERT INTO XS_MIGRATION_CHECK ( NAME, TENANT, ERROR ) SELECT [ID], MAX([SYSCLIENT]),
'DUPLICATE ID IN XSGRP' FROM [XSGRP] GROUP BY [ID] HAVING COUNT([ID]) > 1
INSERT INTO XS_MIGRATION_CHECK ( NAME, TENANT, ERROR ) SELECT [NAME], [SYSCLIENT],
'DUPLICATE FULLNAME IN XSACC' FROM [XSACC] GROUP BY [NAME], [SYSCLIENT] HAVING COUNT(*) > 1
INSERT INTO XS_MIGRATION_CHECK ( NAME, TENANT, ERROR ) SELECT [ID], MAX([SYSCLIENT]),
'DUPLICATE ID IN XSACC' FROM [XSACC] GROUP BY [ID] HAVING COUNT([ID]) > 1
INSERT INTO XS_MIGRATION_CHECK ( NAME, TENANT, ERROR ) SELECT [ACLNAME], [SYSCLIENT],
'DUPLICATE FULLNAME IN XSACL' FROM [XSACL] GROUP BY [ACLNAME], [SYSCLIENT] HAVING COUNT(*) > 1
INSERT INTO XS_MIGRATION_CHECK ( NAME, TENANT, ERROR ) SELECT [NAME], 0, 'DUPLICATE
FULLNAME IN XSMND' FROM [XSMND] GROUP BY [NAME] HAVING COUNT(*) > 1
INSERT INTO XS_MIGRATION_CHECK ( NAME, TENANT, ERROR ) SELECT [ID], 0,
'DUPLICATE ID IN XSMND' FROM [XSMND] GROUP BY [ID] HAVING COUNT(*) > 1
SELECT * FROM [XS_MIGRATION_CHECK]