2023-09-14 12:06:31 -06:00
|
|
|
DROP TABLE OfficeDuplicates;
|
|
|
|
|
Create Table OfficeDuplicates AS
|
2023-09-14 11:28:12 -06:00
|
|
|
SELECT *
|
|
|
|
|
from FolderData AS Origin
|
|
|
|
|
INNER JOIN FolderData AS Dup ON Dup.Project = Origin.Project
|
|
|
|
|
where Origin.Project in (
|
|
|
|
|
select Project
|
|
|
|
|
from FolderData
|
|
|
|
|
group by Project
|
|
|
|
|
HAVING count(*) > 1
|
|
|
|
|
)
|
|
|
|
|
AND Dup.Server != Origin.Server
|
|
|
|
|
ORDER BY Origin.Server,
|
|
|
|
|
Origin.Project;
|
