Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Union order
Message
From
29/08/2008 15:10:56
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Union order
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01343299
Message ID:
01343299
Views:
60
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?
Thanks
Jon
Non-MVP Non-MCP Non-MCSE

Visual FoxPro, What else is there?
Next
Reply
Map
View

Click here to load this message in the networking platform