SELECT Empid, EmpName, OverTime, DoubleTime, TotalHours1 FROM ( -- your select here -- Order by column position instead of names ORDER BY 1,6 ) dt1>I think I got it. Much thanks to you
DECLARE @cJobNo as VARCHAR(10) > >SET @cJobNo = '11709' > >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 empid, Dist>