m.nConnectionHandle = SQLCONNECT('TimeClockPlus') >m.cJobNo = '11708' > >TEXT TO lcCmd NOSHOW PRETEXT 15 > > SELECT TimeHD.Empid, TimeHD.EmpName, > sum(regtime) as RegTime,sum(overtime) as OverTime, Sum(doubletime) as DoubleTime, > sum(regtime+overtime+doubletime) as TotalHours1, > '0' as Dist > FROM TimeHd INNER JOIN > TimeItms ON TimeHd.timecrdno = TimeItms.timecrdno > Where TimeItms.JobNo = ?cJobNo and > TimeItms.[distributed] <> 1 > > group by TimeHD.Empid, TimeHD.EmpName > > UNION ALL > > SELECT TimeHD.Empid, TimeHD.EmpName, > sum(regtime) as RegTime,sum(overtime) as OverTime, Sum(doubletime) as DoubleTime, > sum(regtime+overtime+doubletime) as TotalHours1, > '1' as Dist > FROM TimeHd INNER JOIN > TimeItms ON TimeHd.timecrdno = TimeItms.timecrdno > Where TimeItms.JobNo = ?cJobNo and > TimeItms.[distributed] = 1 > > group by TimeHD.Empid, TimeHD.EmpName > > order by 1,6 > >ENDTEXT > >=SQLEXEC(m.nConnectionHandle,lcCmd,'QueryName') > >*BROWSE LAST NOWAIT > >=SQLDISCONNECT(m.nConnectionHandle)>