Need query to apply schedule to a category

Hi Kathryn - I gather the schedule gets tracked in the salescheduleid field of the item table; backup your database once you're done creating your schedules, then run these select queries first.

select * from schedule (confirm and jot down the id assigned to the schedule you want to assign) select * from category (confirm and jot down the id assigned to the categories you want to affect)

lets say your schedule id is 9 and your category id's are 3 and 4, run a test select query first select * from item where salescheduleid = 9 and categoryid in (3, 4) (this will show you all the items that match your criteria; if all the items you see on the result should be affected by the schedule, you're ready for your update query) REMEMBER TO BACKUP FIRST

your update query is update item set salescheduleid = 9 where categoryid in (3, 4)

to remove the schedule run update item set salescheduleid = 0 where categoryid in (3, 4)

If on the select query you find items that SHOULDN'T have the schedule assigned then you need a "where" constraint on your query (or if its just a few items that shouldn't get changed you can jot down the itemlookupcode and manually remove the schedule from these items after the update query)

H> I have created a sale schedule from 6pm-9pm Wed, Thr & Fri - named it > NightSale. >