UPDATE [Products] SET
   Discontinued = 1
WHERE SupplierID = @SupplierID