Looping through a results table and creating a new view

I am new to Sequel scripting but not SQL.  I just need a little head start on how to create a script that will take the output from a view.  Loop through each record in the record set.  Compute some variables and store the values.  Add the results to the new table.  Clear the variables and move to the next record and repeat until the end of the record set.

Also, 2 of the fields being read in the source record are dates.  What is the syntax to declare the variable that will store the values of these fields?  I did not see a "DATE" format in the documentation.

Thanks

Glen Powers