Stored Procedure - Iteration

Hi there,

I need to create a stored procedure that I can pass in an arbitrarily long list of record IDs and have an SQL statement executed for each one.

For instance, I want to be able to pass in 1, 2, 5, 78, 100, 216 and have it automatically execute:

UPDATE table SET value='blah' WHERE id=1; UPDATE table SET value='blah' WHERE id=2; UPDATE table SET value='blah' WHERE id=5; UPDATE table SET value='blah' WHERE id=78; UPDATE table SET value='blah' WHERE id=100; UPDATE table SET value='blah' WHERE id=216

Can anyone please show me how I would structure a stored procedure like this?  Specifically, how would I pass the list of IDs in as a parameter, and how would I iterate through them.

Much appreciated!!