update #Request.prefix_db_lookup#.Assessment_TimeAuthorizations set ScheduledHours = 0, UsedHours = 0 where Assessment_Tracker_ID = #url.atid# and Assessment_ID = #url.aid# SELECT at.*,si.visit_date,sum(si.Total_units) as total,si.rev_code,si.rev_codeid FROM #Request.prefix_db_lookup#.Assessment_TimeAuthorizations at left outer join #Request.prefix_db_agency#.ScheduleItems si on at.assessment_tracker_id = si.assessment_tracker_id where at.Assessment_Tracker_ID = #url.atid# and at.Assessment_ID = #url.aid# and at.revcode_id = si.rev_codeid and si.visit_date > #CreateODBCDate(now())# group by si.rev_code order by si.rev_code update #Request.prefix_db_lookup#.Assessment_TimeAuthorizations set ScheduledHours = #gettime.total# where Assessment_TimeAuthorizations_ID = #gettime.Assessment_TimeAuthorizations_ID# SELECT at.*,si.visit_date,sum(si.Total_units) as total,si.rev_code,si.rev_codeid FROM #Request.prefix_db_lookup#.Assessment_TimeAuthorizations at left outer join #Request.prefix_db_agency#.ScheduleItems si on at.assessment_tracker_id = si.assessment_tracker_id where at.Assessment_Tracker_ID = #url.atid# and at.Assessment_ID = #url.aid# and at.revcode_id = si.rev_codeid and si.visit_date <= #CreateODBCDate(now())# group by rev_code order by si.rev_code update #Request.prefix_db_lookup#.Assessment_TimeAuthorizations set UsedHours = #GetTimePast.total# where Assessment_TimeAuthorizations_ID = #GetTimePast.Assessment_TimeAuthorizations_ID#