Request 1:
SELECT COUNT (A.EMPNO) AS [PRESENT] FROM ERPDATA.NIITESS.DBO.ZEMP_MASXST_WEB_AL A INNER JOIN PPA_EVENTWISEEMPLOYEEMASTER B ON (CASE B.VC_BA WHEN '%' THEN LTRIM(RTRIM(A.PDIBUSHORT)) ELSE B.VC_BA END) = LTRIM(RTRIM(A.PDIBUSHORT)) AND (CASE B.VC_PA WHEN '%' THEN A.PA ELSE B.VC_PA END) = A.PA WHERE A.STATUS = 3 AND A.EMPNO IN (SELECT VC_EMPCODE FROM ERPDATA.NIITESS.DBO.ADA_MXEASTER WHERE IN_ATTENDANCE_STATUS = 1 AND CH_ACTIVE = 'Y' AND VC_EMPCODE <> '') GROUP BY B.IN_EVENTID
Request 2:
SELECT COUNT (A.EMPNO) AS [TOTAL] FROM ERPDATA.NIITESS.DBO.ZEMP_MASXST_WEB_AL A INNER JOIN PPA_EVENTWISEEMPLOYEEMASTER B ON (CASE B.VC_BA WHEN '%' THEN LTRIM(RTRIM(A.PDIBUSHORT)) ELSE B.VC_BA END) = LTRIM(RTRIM(A.PDIBUSHORT)) AND (CASE B.VC_PA WHEN '%' THEN A.PA ELSE B.VC_PA END) = A.PA WHERE A.STATUS = 3
I want to combine two results in two columns with a missing column = query 2 - query 1 to speed up. How can I do it? EXAMPLE:
I have TWO RESULTS:
// ---------------------------------------- QUERY: 1
1
2
3
4
// -------------------------------------- QUERY: 2
4
5
6
eight
// ------------------------------------ OUTCOME AS in two columns
fifteen
2 6
3 7
4 8
source share