Re: 1 SP with dynamic input parameters and multiple rows as the source of the query
why not use crystal reports or excel or access or some user friendly
front end that is designed to let the users access the database and
next, those pesky users will want the headers bolded, rearrange the
order of columns, totals, etc.
create a few views. create a few fishing poles, and teach the
multitudes how to fish on their own.