Delete all items that don't have a description

(0) Share

Report

Posted on by jdc03

890

Long story short, a few items were added that should not have been. The easiest way to spot these items is the fact that they are the only ones that do not a have description.

Can I run a sql script to remove all of these? Or might I have to delete them one by one?

*This post is locked for comments

All responses (4)

Answers (1)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Delete all items that don't have a description

You can run a script to delete however this is not recommended, deleting items can lead to corrupt data. Best practice is to inactivate the items. This could also be done through a script.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Delete all items that don't have a description

You can run a script to delete however this is not recommended, deleting items can lead to corrupt data. Best practice is to inactivate the items. This could also be done through a script.
jdc03 890 on at

Like (0)

Report

RE: Delete all items that don't have a description

Unfortunately that kicked back an error, and when I tried just Description = null it came back with 0 results ... but I was able to get it to work by Price = 0, another trait they all shared.
Verified answer

archelle16 1,735 on at

Like (0)

Report

RE: Delete all items that don't have a description

The fastest move you can do is to query since you're sure that these were not used.

DELETE FROM ITEM WHERE Description = null OR Description = ''