Can someone help me woth an SQL command to remove Items that wer imported on accident? I need to remove the items with the following information:
Inactive=yes Price=$0.00 Date created=8/24/2009
Any help would be appreciated Thank-you Adam
Sql Command for HQ
Aug 25, 2009
1 Replies
You can do so select * from item where inactive=0 and price=0 and convert(char(12),DateCreated,101)='08/24/2009' once satisfy with above query, then run this
delete item where inactive=0 and price=0 and convert(char(12),DateCreated,101)='08/24/2009'
"akpetsh> Can someone help me woth an SQL command to remove Items that wer imported on
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required