How can I run through an array of ID's and delete the fields associated to it in a single table?  I have a lot of bad data that needs to be removed.  BTW, I'm using the SQL Server Management Studio to do this.

I'm currently doing by hand by using the following.

USE database;
DECLARE @id integer
SET @id = XXXXX

DELETE FROM table WHERE id = @id;

I would like to use the same code but with a slight variation to support an array.

Where are you getting the array of IDs?

How do you know the IDs of bad data? If you have an answer you should be able to write a query to delete them.

Well right now I'm having to look through the table for the bad data and make a list.

You can list your IDs in the following query:

DELETE FROM YourTable WHERE id IN (1, 2, 3, .