I'm trying to get the results of the following queries combined, but can't figure out how. Can someone please help?
SELECT @quizCount = 0, @completedCount = COUNT(DISTINCT ac.assignmentId), @userId = userId
FROM dbo.assignments_completed ac
INNER JOIN dbo.assignements a ON ac.assignmentId = a.assignmentId
WHERE userId IN (SELECT userId FROM users WHERE mgrUserId = @managerId) AND
a.sourceType = @INDQUIZ AND
a.enabled = 1
GROUP BY userId
SET @CompletedTotal = @CompletedTotal + @completedCount;
INSERT INTO @temp
SELECT @quizCount, @CompletedTotal, @userId
SELECT @quizCount = 0, @completedCount = COUNT(DISTINCT ac.assignmentId), @userId = qc.userId
FROM dbo.assignments_completed ac
INNER JOIN dbo.quizzes_completed qc ON ac.assignmentId = qc.eventId
INNER JOIN dbo.assignements a ON ac.assignmentId = a.eventId
WHERE qc.userId IN (SELECT userId FROM users WHERE mgrUserId = @managerId) AND
a.sourceType = @GRPQUIZ AND
a.enabled = 1
GROUP BY qc.userId
SET @CompletedTotal = @CompletedTotal + @completedCount;
INSERT INTO @temp
SELECT @quizCount, @CompletedTotal, @userId
SELECT @quizCount = 0, @completedCount = COUNT(DISTINCT ac.assignmentId), @userId = qc.userId
FROM dbo.assignments_completed ac
INNER JOIN dbo.quizzes_completed qc ON ac.assignmentId = qc.eventId
INNER JOIN dbo.assignements a ON ac.assignmentId = a.eventId
WHERE qc.userId IN (SELECT userId FROM users WHERE mgrUserId = @managerId) AND
a.sourceType = @SUMQUIZ AND
a.enabled = 1
GROUP BY qc.userId
SET @CompletedTotal = @CompletedTotal + @completedCount;
INSERT INTO @temp
SELECT @quizCount, @CompletedTotal, @userId
SELECT DISTINCT u.userId, u.fname, u.lname, t.quizCount AS 'Current', t.completedCount AS 'Completed'
FROM users u
INNER JOIN @temp t ON u.userId = t.userId
WHERE mgrUserId = @managerId
Thanks.