SELECT * FROM PECOS WHERE NPI IN ( SELECT DISTINCT Phys_NPI FROM #Request.prefix_db_lookup#.pPhysicians) UPDATE #Request.prefix_db_lookup#.pPhysicians SET Phys_verified = 0 UPDATE #Request.prefix_db_lookup#.pPhysicians SET Phys_verified = 1 WHERE Phys_NPI IN ()