Select .... Where The Item.ID Is In This Array?

Hiya,


I want to populate a list view (in a variety of ways), but I would rather
not execute my function once for every record I want to show in the list.
What I want to do is pass an array of "keys" into a stored procedure and
have that procedure return one recordset with all of the records in. So
what I want to do is something like:

CREATE PROCEDURE MySuperProcedure

@MyArrayOfIDs (some way of specifying an array of integers),

AS


SELECT *
FROM MyTable
WHERE MyArrayOfIDs.ContainsTheInteger ( MyTable.ID )


Obviously this syntax is not available. Is there another way of doing this?