Join two results sets to make one result set in T-SQL
Posted
by Michael Kniskern
on Stack Overflow
See other posts from Stack Overflow
or by Michael Kniskern
Published on 2010-05-27T21:38:23Z
Indexed on
2010/05/27
21:41 UTC
Read the original article
Hit count: 97
Filed under:
tsql
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
© Stack Overflow or respective owner
