SELECT @Count=COUNT(Id) FROM #RecordTempSET @i=0WHILE @i<@CountBEGINSET @i=@i+1SELECT @Id=Id,@CoachIcNo=CoachIcNo,@StuIcNo=StuIcNo,@BeginTime=BeginTime,@EndTime=EndTime,@ActualTime=ActualTime,@StudyMile=StudyMile,@StudyType=StudyType,@Satisfaction=Satisfaction,@SchoolNo=SchoolNo,@TerminalNo=TerminalNo,@ExeState=ExeState,@S_IcSerialNo=S_IcSerialNo,@C_IcSerialNo=C_IcSerialNo,@SchoolId=SchoolId,@StuId=StuId,@RegDate=RegDate,@CoachId=CoachId,@CarCardNo=CarCardNo,@StuTechType=StuTechType,@CarTechType=CarTechType,@CoachTechType=CoachTechType,@CoachDriveType=CoachDriveType,@CoachTeachType=CoachTeachType,@StudentIcSerialNo=StudentIcSerialNo,@CoachIcSerialNo=CoachIcSerialNo,@ExeTime=ExeTime,@StuLeftTime=StuLeftTime,@VersionNo=VersionNoFROM #RecordTempWHERE RowId=@i