...or a better way to do this.
Below is my stored procdure:
CREATE PROCEDURE [dbo].[spSimonTest] @review as nvarchar(100)
AS
SELECT commArea, COUNT(*) as areaCount, count(commAppEng) as engAppCount, count(commAppCompany) as companyAppCount, count(commAppClient) as clientAppCount FROM...