SELECT TABLE_SCHEMA FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA like '%agency%' group by TABLE_SCHEMA

Deleted all those Duplicate records

SELECT t1.* FROM #Request.prefix_db_agency#.pAssessments t1 INNER JOIN #Request.prefix_db_agency#.pAssessments t2 WHERE t1.AutoAssmt_ID < t2.AutoAssmt_ID AND t1.Status = 0 AND t2.Status = t1.Status AND t1.Assmt_ID = t2.Assmt_ID AND t1.Record_Mod_Date like '2024-07-18 08:19%' UPDATE #Request.prefix_db_agency#.pAssessments SET status = 2 WHERE AutoAssmt_ID= '#gets.AutoAssmt_ID#' AND Status = 0 AND Record_Mod_Date like '2024-07-18 08:19%'