Thanks for everybody's help.
I discovered that a stored proc will return multiple result sets. For some (obviously incorrect) reason, I thought a single SP would only return 1 result. But if I do a...
SELECT SOURCETABLE.* INTO #TEMPTABLE JOIN 'BLAH BLAH' WHERE 'BLAH BLAH'
SELECT * FROM #TEMPTABLE
SELECT ACCOUNT,SUM(AMOUNT) FROM #TEMPTABLE GROUP BY ACCOUNT
GO
I get a dataset at the other end with two data tables inside...just the way I needed it!
Kevin