>I've got a select statement that I'm unioning and my results come back with the second select statements data in the first row and the first selects data in the second row.
>
>Here's the statement:

>SET @cJobNo = '11708'
>
>SELECT TimeHD.Empid, TimeHD.EmpName,
>	sum(regtime) as RegTime,sum(overtime) as OverTime, Sum(doubletime) as DoubleTime,
>	sum(regtime+overtime+doubletime) as TotalHours1
>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
>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

>I've tried switching the where clauses around but it doesn't seem to matter. Any ideas?


It should be sorted by EmpID. Do you have two records with the same ID? If yes, create a SortOrder field to sort the way you want explicitly.

BTW, funny, it's 2 seconds difference between my answer and Sergey's.