April 27, 2011 at 1:53 pm
Is there a way to get mulitple counts from the following script:
Select Count(FirstCommunityChoice) as 'Community'
From dbo.tblApplicationCommunities
Where FirstCommunityChoice = 'Eagle Butte'
This returns the count of communities where the community is equal to Eagle Butte
I need to have return a count for each distinct community name contained in the column FirstCommunityChoice.
Warm Regards,
Arthur Lorenzini
Sioux Falls, SD
April 27, 2011 at 2:05 pm
Select FirstCommunityChoice, Count(FirstCommunityChoice) as 'Community Count'
From dbo.tblApplicationCommunities
Group By FirstCommunityChoice
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
April 27, 2011 at 2:38 pm
I suppose this is where I say duhhhhH! Thank you that worked perfectly!
Warm Regards,
Arthur Lorenzini
Sioux Falls, SD
April 27, 2011 at 2:52 pm
What is difficult today becomes trivial tomorrow. Or so I hope. 😛
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply