Need to change commission setting only shoe dept

Perform the following steps

Step 1 - Run the following SQL query and note the ID for the shoe department

Select * FROM Department

Step 2 - Run the following SQL query and change 999 to the ID for the shoe department and note the number of records

SELECT ItemlookupCode, Description, DepartmentID, CommissionMode FROM Item WHERE DepartmentID = 999

Step 3 - Run the following SQL query and change 999 to the ID for the shoe department and note the number of records updated (This should be the same as the number of records from step 2)

UPDATE Item SET Item.CommissionMode = 1 FROM Item INNER JOIN Department ON Item.DepartmentID = Department.ID WHERE Item.DepartmentID = 999

Step 4 - Run the SQL query from step 2 again and the CommissionMode column should all be 1

Awsome thanks Michael

that worked perfectly

"Michael" wrote:

You need to add the additional criteria to the Update query

UPDATE Item SET Item.CommissionMode = 1 FROM Item INNER JOIN Department ON Item.DepartmentID = Department.ID WHERE Item.DepartmentID = 999 AND Item.Price > 39.99