>>My suggestion is to have multiple stored procedure and let your data access component call the correct one.
>
>Thanks, but what if I have to retrieve all 3 different results?

You could make three calls back to the server. One for each result set.

-Mike