Stored procedure - need help constructing a stored procedure - may be avoid using DO WHILE loop

Running Small Business  Server 2003 premium which has SQL server 2000.

Im trying to determine how best to construct my stored procedure.
Right now I have 2 tables, tblSymbol and tblData.  
tblSymbol contains distinct symbols.  No duplicates.

In psuedo code the process is:
-      Get a symbol from tblSymbol
-      Get volume, high price, low price and closing price from tblData
-      Loop thru the 1st 10 records in tblData, sum the value of (closing price  low price)
-      When done summing 10 records, divide the sum by the average volume of the 10 records
-      * On the 11th record,   get the closing price and low price from the 10th record.  Lets call that Cl10 and LP10
-      Subtract RCL = (CL11  CL10) and RLP = (LP11  LP10).  So RCL is the difference between closing prices and RLP is difference between low prices.  Now add Vol2 + Vol3 + Vol4 etc to Vol11.  Divide this sum by Vol11.  So now there is a moving average of volume.  
-      Divide RCL / moving avg of volume.
-      Finally write the result to tblOutput.
-      Go back to the line with the * and subtract the data in the 11th row from the data in the 12th row of data, etc.  Keep looping until all data is exhausted.

The only way I can think of doing this is do construct a DO WHILE loop:
-      Loop thru tblSymbol

Feed  each  symbol to a stored procedure  (see procedure A1 below)

Create a temporary table containing the one symbol and all data from tblData using the output from the stored procedure below. Write all this data to a temp table where the first field is an IDENTITY.  Lets call the temp table tblTemp.

So tblTemp is defined as:
 RecID   (an IDENTITY)
 Symbol
 Volume
  Lowprice
  Highprice

Since tblTemp has an IDENTITY I can then loop thru it using a DO WHILE loop.
When I need a previous record (see my discussion above about 10th and 11th record) as the loop progresses I can find the previous record using its RecID.

When I am finished with all the records in tblTemp, then I would have to destroy tblTemp, recreate it and load it with records from the next symbol.  Why?  That way I know the first RecID will always = 1.

My questions:
-      If I make tblTemp a table variable, what performance hit do I experience each time tblTemp is recreated?

-      What better way is there to do this?


=========================== procedure A1 =================
CREATE procedure A1
As
   @strSymbol      varchar(7),
   @datBegin   smalldatetime,
   @datEnd    smalldatetime
SELECT stk.Symbol,
       stk.EntryDate,
       stk.Volume,
       stk.fOpen,
       stk.High
FROM   dbo.tblStockData  stk
INNER JOIN dbo.tblDistinctSymbols dist
   ON (dist.Symbol = stk.Symbol)
WHERE dist.Symbol = @strSymbol
  AND stk.Active = 1
  AND stk.EntryDate BETWEEN @datBegin   AND @datEnd    
GROUP BY stk.Symbol, stk.EntryDate, stk.Volume, stk.fOpen, stk.High
ORDER BY stk.EntryDate

Return