在SQL Server 2014中垂直连接2个查询输出 [英] Joining 2 queries output vertically in SQL Server 2014

问题描述

如何加入2个选择查询

How do i join 2 select queries

SELECT DATENAME(DW,Dated) as Days, FinalTime
  FROM [Attendance].[dbo].[AttnDaily]
  where EmpID=111 and Dated>='2015-09-14' and Dated<='2015-09-18'

输出：

OUTPUT:

Days	        FinalTime
Monday	        09:23:27
Tuesday	        08:55:50
Wednesday	    08:52:38
Thursday	    00:00:00
Friday	        10:31:53

SELECT 'Total Hours', cast(sum(datediff(second,0,[FinalTime]))/3600 as varchar(12)) + ':' + 
        right('0' + cast(sum(datediff(second,0,[FinalTime]))/60%60 as varchar(2)),2) +
        ':' + right('0' + cast(sum(datediff(second,0,[FinalTime]))%60 as varchar(2)),2) 
  FROM [Attendance].[dbo].[AttnDaily]
  where EmpID=111 and Dated>='2015-09-14' and Dated<='2015-09-18'

输出：

OUTPUT:

(No column name)  (No column name)
Total Hours	         37:43:48

必需输出：

Required Output:

Days	        FinalTime
Monday	        09:23:27
Tuesday	        08:55:50
Wednesday	    08:52:38
Thursday	    00:00:00
Friday	        10:31:53
Total Hours	    37:43:48

推荐答案

尝试：

Try:

SELECT DATENAME(DW,Dated) as Days, FinalTime
  FROM [Attendance].[dbo].[AttnDaily]
  WHERE EmpID=111 and Dated>='2015-09-14' and Dated<='2015-09-18'
UNION ALL
SELECT 'Total Hours' As Days, CONCAT(cast(sum(datediff(second,0,[FinalTime]))/3600 as varchar(12)), ':' , 
        right('0' + cast(sum(datediff(second,0,[FinalTime]))/60%60 as varchar(2)),2) ,
        ':' , right('0' + cast(sum(datediff(second,0,[FinalTime]))%60 as varchar(2)),2)) AS FinalTime
  FROM [Attendance].[dbo].[AttnDaily]
  WHERE EmpID=111 and Dated>='2015-09-14' and Dated<='2015-09-18'

进一步请参阅：

UNION [ ^ ]

CONCAT [ ^ ]

这篇关于在SQL Server 2014中垂直连接2个查询输出的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！