IF(@IsScoped = 0) BEGIN SELECT ds.DisplayString Tier, count(*) ActiveCount FROM [WorkItem] wi LEFT JOIN [Enumeration] enum ON enum.EnumerationID = wi.CategoryId LEFT JOIN [DisplayString] ds ON ds.ElementID=enum.EnumerationID WHERE wi.ClassId IN ('7AC62BD4-8FCE-A150-3B40-16A39A61383D') AND wi.StatusId NOT IN('9de908a1-d8f1-477e-c6a2-62697042b8d9','144bcd52-a710-2778-2a6e-c62e0c8aae74','EAEC5899-B13C-D107-3E1A-955DA6BF9FA7','89465302-2A23-D2B6-6906-74F03D9B7B41') AND ds.LocaleID=ISNULL(@LanguageCode, 'ENU') GROUP BY ds.DisplayString END ELSE BEGIN SELECT ds.DisplayString Tier, count(*) ActiveCount FROM [WorkItem] wi LEFT JOIN [Enumeration] enum ON enum.EnumerationID = wi.CategoryId LEFT JOIN [DisplayString] ds ON ds.ElementID=enum.EnumerationID LEFT JOIN [Access_CI$User_WorkItem] a ON wi.Id = a.WorkItemId WHERE wi.ClassId IN ('7AC62BD4-8FCE-A150-3B40-16A39A61383D') AND wi.StatusId NOT IN('9de908a1-d8f1-477e-c6a2-62697042b8d9','144bcd52-a710-2778-2a6e-c62e0c8aae74','EAEC5899-B13C-D107-3E1A-955DA6BF9FA7','89465302-2A23-D2B6-6906-74F03D9B7B41') AND ds.LocaleID=ISNULL(@LanguageCode, 'ENU') AND a.UserId=@UserId GROUP BY ds.DisplayString END