DebbieDavis
Programmer
Hi there,
I'm sure this is an elementary question but I'm not as SQL proficient as I'd like to be. I have a view with two tables to display data from on my page. Do I have to create a recordset for each task if I need a count and a sum of different things in the view, i.e. there are registrants that have paid full price, registrants that have discounts and registrants that are comp, and I need a count and a sum for each of those groups. Do I have to create three separate recordsets? I do not know how to do stored procedures. Can this be done in one stored procedure? Thanks for your input.
I'm sure this is an elementary question but I'm not as SQL proficient as I'd like to be. I have a view with two tables to display data from on my page. Do I have to create a recordset for each task if I need a count and a sum of different things in the view, i.e. there are registrants that have paid full price, registrants that have discounts and registrants that are comp, and I need a count and a sum for each of those groups. Do I have to create three separate recordsets? I do not know how to do stored procedures. Can this be done in one stored procedure? Thanks for your input.