counter variable renamed 'iDs'
set up iterations to fill 'tmpSpectralData' fields
new tables 'tmpSpectralDataForUpdate', 'tmpSpectralDataToUpdate'
clear 'tmpSpectralDataForUpdate'
SQL for 'tmpSpectralDataForUpdate'
begin loop for 'tmpSpectralDataToUpdate'
SQL to fill 'tmpSpectralDataToUpdate'
keep only 'tmpSpectralDataToUpdate' that have minimum time difference
remove any 'tmpSpectralDataToUpdate' duplicates
update field in 'tmpSpectralData'
finish, if only getting two bands into 'tmpSpectralData'
'GetDaySpectralData' fn finished, still need to test
fixed SQL bugs in 'GetDaySpectralData' fn