union or subquery? how can i put these two queries together to get result below
thanks
here my 2 queries
.......
SELECT Count( DISTINCT Create_Date) 'Total Escalation',
Submitter 'Remedy Id',
(EMP_FRST+' '+EMP_LAST) AS Agent,
(SUP_FRST+' '+SUP_LAST) AS Supervisor,
(MGR_FRST+' '+MGR_LAST) AS Manager,
Group_Assigned_To 'Group Assigned To', (getdate() - 1) as stampdate

FROM RemWebReports.dbo.raw_data
inner join WebForms.dbo.CNS on Submitter = remedy_ID
WHERE datediff(day, Create_Date, GetDate()) = 1 and IsDate(Create_Date) = 1 and Status <> 'closed'
GROUP BY (MGR_FRST+' '+MGR_LAST), (SUP_FRST+' '+SUP_LAST), (EMP_FRST+' '+EMP_LAST),Group_Assigned_To, Submitter
ORDER BY (MGR_FRST+' '+MGR_LAST), (SUP_FRST+' '+SUP_LAST), (EMP_FRST+' '+EMP_LAST),Group_Assigned_To,Submitter

query 2

SELECT Count( DISTINCT Create_Date) 'Total call vol',
Submitter 'Remedy Id',
(EMP_FRST+' '+EMP_LAST) AS Agent,
(SUP_FRST+' '+SUP_LAST) AS Supervisor,
(MGR_FRST+' '+MGR_LAST) AS Manager, (getdate() - 1) as stampdate

FROM RemWebReports.dbo.raw_data
inner join WebForms.dbo.CNS on Submitter = remedy_ID
WHERE datediff(day, Create_Date, GetDate()) = 1 and IsDate(Create_Date) = 1
GROUP BY (MGR_FRST+' '+MGR_LAST), (SUP_FRST+' '+SUP_LAST), (EMP_FRST+' '+EMP_LAST), Submitter
ORDER BY (MGR_FRST+' '+MGR_LAST), (SUP_FRST+' '+SUP_LAST), (EMP_FRST+' '+EMP_LAST), Submitter ASC
.........
basically same querie with diff where clause
i want to get result together like
'Total Escalation' 'Total call vol' 'Remedy Id', Agent,Supervisor, Manager, stampdate

b./c im trying to calculate percentage b/w 'Total Escalation' and 'Total call vol'