Run SQL procedure

[billylodz]

Hi all

RS 8.3  SQL 2005

I have SQL query in RS and Stored procedure which return recordset.

the result I want to display in 3 lists. there is a key column to filter records.
I have 3 addistional queries which take the results from main (procedure) query and Ifilter it with key column.

the problem is that because I have 3 lists and 3 queries (but all 3 take data from one main) the procedure on SQL runs 3 times.   is any way to run it once. or any other ideas haw to display the results with just one run of procedure.