INSERT INTO SEGMENT_TRAFFIC_2009
  (AGENCYID, CALENDARYEAR, AADTVPD,PERCENTHEAVYVEHICLES,PEAKHOURLYVOLUME)
  
  select a.segmentid as agencyid, a.aadt_year as calendarYear, a.aadtvpd,
  a.percentheavyvehicles, a.peakhourlyvolume
  from segmenttraffic a; 
   

