Items no longer needed

A 401 won't help at all.

There is no worksheet for deleting items at the store level.

As far as queries go, if you have the list of ILCs in some manageable format you can create a series of query statements in Excel by using text formulas. For example, at the store ops level, the sql statement would be:

DELETE from Item WHERE ItemLookupCode = 'XXX'

At HQ, you might need to export the results of a query that gives you ID & ILC from the Item table then delete the IDs from the ItemDynamic table. This could be complicated and you could screw up *big time*.

Maybe somebody else has a better idea.

Tom

Hi, I want to delete (not make inactive) many items we no longer need and no longer need to refer to any transaction history. I want to delete them from the HQ database and then make sure the corresponding items are deleted at all 10 stores. If I delete the item at HQ will a corresponding delete occur at the store when a 401 worksheet runs? Or do I need to issue a (massively long - many thousands of items) sql statement to do this? What would the sql be to delete the item, its corresponding record in itemdynaic and any transaction histories associated with the item. Thanks in advance.

-- Regards

Dan