Stored procedure help...

[E3]

Itemid Sellername
----------- -----------
1 Sandy
2 Sandy


Bidid Buyerid Buyername Itemid
----------- ----------- ------------ -----------
1 1 Mark 1


How do I write the sql statements to pass the the itemid 1 and 2 to bids so I can delete the related data from bids table given "Sandy"

Is there a loop that i can write in stored procedures or something?
I believe I read something on store procedures calling stored procedures, isit the one that can solve my prbs?

 

[E3]

The problem is when I select the IDS for Sandy, what it returns is a collection. How do I pass each of the values to the delete sql?