Cursors

Hi,





I'm writting a stored procedure to insert new rows into a table, but I need to loop through an exsiting table and create a new record for every row in the old table. So I think what I'm needing to use is a cursor, but I've never worked with cursors before, and I just want to check that I have the right idea on what they are used for and if what I have so far looks ok.





This what I have so far, the StoreFees table only has 5 rows:








DECLARE @StoreFee as smallmoney


DECLARE @StoreLineID as int





DECLARE MyStoreFees CURSOR


FORWARD_ONLY


FOR


SELECT LineId, StoreFee FROM StoreFees ORDER BY StoreFee





OPEN MyStoreFees





FETCH NEXT FROM MyStoreFees


INTO @StoreLineId, @StoreFee





--Do my Inserts into other tables


INSERT INTO OtherTable (...,...,.., @StoreFee)


...


...


-- Done working with that row





CLOSE MyStoreFees