>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?

My main SP then has to call 3 different SPs? But how the main would see the results of them? Or should I create these 3 as a UDF (returning table) and call them this way in one SP?

Or just do 3 select statemens in the ASP itself without SP (or call 3 times 3 different SPs)?

What would you suggest?

Thanks again.