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