I WANT TO GENERATE ASCENDING SERIES FOR EACH SURVEY_ID BASED ON CHAINAGE SEQUENCE. FOR EXAMPLE NUMBER OF RECORDS IN FIRST SURVEY ID ARE 8 AND ITS CAINAGE STARTS WITH 23 AND ENDS AT 93, SO IN SERIES FIELD SEQUENCE AUTOMATICALLY GENERATE FROM 1,2,3.. TO 8. SIMILARLY IN SECOND SURVEY_ID RECORDS ARE 10 THEN SERIES SHOULD BE 1,2,3,....,10 FOLLOWING THE CHAINAGE SEQUENCE
أكثر...
أكثر...