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.