>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.
If it's not broken, fix it until it is.
My Blog