You cannot expect records to be in any particular order w/o ORDER BY clause. Add one more column, put 1 for the first select and 2 for second select and ORDER BY on it.

>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?