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: 123

Filed under:

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

Related posts about tsql