Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention. Check out this how-to article for more information.
Select N.Number as [Month], Year(@Year) as [Year], Count(tblUE.UserExternaliD) From dbo.Numbers as N left outer join tblUserExternal as tblUE on n.Number = datepart(mm, tblUE.UserExternalDateSignUp) and tblUE.UserExternalDateSignUp >= @Year and tblUE.UserExternalDateSignUp < DATEADD (yy,1,@Year) where n.Number between 1 and 12 Group by N.Number Order by N.Number;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.