Home Forums SQL Server 2005 T-SQL (SS2K5) SET value WHERE Product has > 2 Suppliers RE: SET value WHERE Product has > 2 Suppliers
Ramesh Saive
SSC-Insane
Points: 24275
More actions
February 6, 2009 at 9:13 am
#939615
I think the OP wants to update products where suppliers for that product > 2. So, should the rows be filtered by COUNT(1) > 2?
--Ramesh