You could use output parameters to a proc. eg
Code:
CREATE PROCEDURE MyProc
@Sum1 Int OUTPUT, @Sum2 Int OUTPUT, @Sum3 Int OUTPUT
AS
SET NOCOUNT ON
SELECT @Sum1 = SUM(Price1), @Sum2 = SUM(Price2), @Sum3 = SUM(Price3)
FROM SomeTable
SELECT Price1, Price2, Price3
FROM SomeTable
You need to use a command object to execute the proc and get the output parameters. Also there can be problems with accessing output parameters and recordsets. From memory you can only get the output parameters once the recordset is closed. It might be the other way around.
regards
David Cameron