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
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.