Delete multiple items

Hi Experts

I am Very, very new to SQL and need a bit of help.  I need to create a delete statement that
can handle multiple items in the wholesaleID.  Here is the statement that I use
when I am deleting 1 condition at a time.  Very time consuming.  

DELETE
FROM [NYP-RetailDataSQL].dbo.[Sales-Compare918A]
WHERE WholesaleID = '99-MW' AND [Data Date] = '2012-09-11'

I would like to also delete 12-MW, 14-MA, 22-SW, 30-MA, 88-SW which are wholesaleID's.  
Is there a way to incorporate these items into the single item statement so that I am not having to go back change it one at a time?

Much thanks

spudmcc
spudmccAsked:
Who is Participating?
 
borkiConnect With a Mentor Commented:
This might work:

DELETE
FROM [NYP-RetailDataSQL].dbo.[Sales-Compare918A]
WHERE (WholesaleID IN ('99-MW', '12-MW', '14-MA', '22-SW', '30-MA', '88-SW') )
   AND [Data Date] = '2012-09-11'
0
 
spudmccAuthor Commented:
Perfect.  Thanks so much for the quick response and your time.  

A
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.