troubleshooting Question

Subquery grouping

Avatar of Brogrim
BrogrimFlag for Ireland asked on
Microsoft SQL Server
3 Comments1 Solution272 ViewsLast Modified:
I am attempting to group data from a sub query

The 1st part is to filter teh records works fine

SELECT     YEAR(dbo.tblMemberROC.CommensementofService) AS Expr1, dbo.tblMemberROC.ROCSUStatusID AS Expr2
FROM         dbo.tblMemberROC INNER JOIN
                      dbo.tblMember ON dbo.tblMemberROC.MemberID = dbo.tblMember.MemberID
WHERE     (dbo.tblMemberROC.ROCSUStatusID = 3 OR
                      dbo.tblMemberROC.ROCSUStatusID = 4))

I now want to group the records using this sql


SELECT     YEAR(dbo.tblMemberROC.CommensementofService) AS Expr3, COUNT(dbo.tblMemberROC.ROCSUStatusID) AS Expr4
GROUP BY YEAR(dbo.tblMemberROC.CommensementofService)

Where (
SELECT     YEAR(dbo.tblMemberROC.CommensementofService) AS Expr1, dbo.tblMemberROC.ROCSUStatusID AS Expr2
FROM         dbo.tblMemberROC INNER JOIN
                      dbo.tblMember ON dbo.tblMemberROC.MemberID = dbo.tblMember.MemberID
WHERE     (dbo.tblMemberROC.ROCSUStatusID = 3 OR
                      dbo.tblMemberROC.ROCSUStatusID = 4))
ASKER CERTIFIED SOLUTION
tim_cs

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros