I am trying to run a query to possibly delete some items from the database. I still can't access customersource because there was a typo on my email address. Waiting on Microsoft to correct.
I want to run a query to list all items with supplierid as 4 then delete those items that have a quanity less then 1.
I have already made a backup. Any help would be greatly appreciated!
Lisa,
-- Preview what will be deleted SELECT * FROM Item WHERE SupplierID=4 AND Quantity < 1
-- Delete DELETE Item WHERE SupplierID=4 AND Quantity < 1
- Evan Culver New West Technologies
Lisa,
-- Preview what will be deleted SELECT * FROM Item WHERE SupplierID=4 AND Quantity < 1 AND Inactive=0 -- Delete DELETE Item WHERE SupplierID=4 AND Quantity < 1 AND Inactive=0
- Evan Culver New West Technologies
Have something to add? Share your thoughts — no account required.
Ask the community — no account required