<< Can you use a view instead of a stored proc for spu_Test_A? >>

I've got about 20,000,000 (and growing) records I'm dealing with. I want to send parameters to spu_Test_A so...

How do I group (or whatever) on the record set returned?

CREATE PROCEDURE dbo.spu_Test_B AS

Exec spu_Test_A

Select col0, Sum(col1) as col1 From ????? Group...