SQL Statement for Adding Food Stamp Option to Non-Tax Items

Aug 11, 2008 1 Replies
F

Hi,



I have a grocery store and have inputted about 1600 items. However, I only recently realized that I need to check the 'Accept Food Stamps for this Item' option for each item I add.



It would take me quite a long time to do this. Can anyone help me with an SQL statement that I can use in SO Admin to apply the Food Stamp Option to all NON-Tax Items?



If this is not possible, can some help me with a statement that will make all the items in the database have the 'food stamp option' checked? I have a lot less tax items, and unchecking them would be alot faster.



Thanks!


Vote
Twitter Facebook LinkedIn
K

Hi,

To make all items to accept food stamps: update Item set FoodStampable=1 To add that to NON-Tax Items: update Item set FoodStampable=1 where TaxID=0

Koit Lahesoo

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required