Just Create A tempTable with the structure of the Recordset returned by the sp and use the insert exec construct like:

declare @TimesToRun int

        ,@blkidM int

        ,@blkid1 int

        ,@blkid2 int

        ,@blkid3 int

set @TimesToRun = 3

set @blkid1 = 218645

set @blkid2 = 218646

set @blkid3 = 218647

set @blkidM = @blkid1

 Create Table #T (fld1 ,fld2 ,fld3..)

while @TimesToRun > 0

begin

INSERT #T (fld1 ,fld2 ,fld3..) execute dbo.DensityGrad @blkid = @blkidM

set @TimesToRun = @TimesToRun – 1

set @blkidM = @blkid2

end

Select * from #T1

you will also have to change your parameter to use a list of values sepparated by a comma or with equal spacing so that you can automate the parameter passing too!

HTH