Untitled

SELECT 'WAREHOUSE' AS COLUMN_NAME, WAREHOUSE AS DUPLICATE_VALUE, COUNT(*) AS DUPLICATE_COUNT
FROM TL2.BI_VIEW.ACTIVE_LOCATION_UTILIZATION
GROUP BY WAREHOUSE
HAVING COUNT(*) > 1
UNION
SELECT 'COMPANY' AS COLUMN_NAME, COMPANY AS DUPLICATE_VALUE, COUNT(*) AS DUPLICATE_COUNT
FROM TL2.BI_VIEW.ACTIVE_LOCATION_UTILIZATION
GROUP BY COMPANY
HAVING COUNT(*) > 1
UNION
SELECT 'ZONE' AS COLUMN_NAME, ZONE AS DUPLICATE_VALUE, COUNT(*) AS DUPLICATE_COUNT
FROM TL2.BI_VIEW.ACTIVE_LOCATION_UTILIZATION
GROUP BY ZONE
HAVING COUNT(*) > 1
UNION
SELECT 'ASSIGNMENTZONE' AS COLUMN_NAME, ASSIGNMENTZONE AS DUPLICATE_VALUE, COUNT(*) AS DUPLICATE_COUNT
FROM TL2.BI_VIEW.ACTIVE_LOCATION_UTILIZATION
GROUP BY ASSIGNMENTZONE
HAVING COUNT(*) > 1
UNION
SELECT 'SIZE' AS COLUMN_NAME, SIZE AS DUPLICATE_VALUE, COUNT(*) AS DUPLICATE_COUNT
FROM TL2.BI_VIEW.ACTIVE_LOCATION_UTILIZATION
GROUP BY SIZE
HAVING COUNT(*) > 1
UNION
SELECT 'MAXVOLUME' AS COLUMN_NAME, MAXVOLUME AS DUPLICATE_VALUE, COUNT(*) AS DUPLICATE_COUNT
FROM TL2.BI_VIEW.ACTIVE_LOCATION_UTILIZATION
GROUP BY MAXVOLUME
HAVING COUNT(*) > 1