I am very new to SQL Server and have a basic question. I need to lookup information for a list (lets say 100 members) for a certain date range. I would like to use a stored procedure but I am having a problem trying to figure out how to send and process the list of members and returning a finished cursor to be reported from. Can anyone give me some advice on the fastest (best) method of handling this?

Thanks in advance
Kelly