Join two results sets to make one result set in T-SQL
- by Michael Kniskern
What would be the best approach to combine the two results sets in one result set in T-SQL?
SQL statment #1:
SELECT
COUNT(t.col1) as 'Number of Responses',
t.col2 as 'Department'
FROM table t
WHERE col3 IS NOT NULL
GROUP BY t.col1
ORDER BY t.col1
SQL Statment #1:
SELECT
COUNT(t.col1) as 'Total number of participants',
t.col2 as 'Department'
FROM table t
GROUP BY t.col1 ORDER by t.col1
Desired result set
Number of Responses | Total Number of
participants | Department
