I'm trying to Query an existing SQL server DB that contains voting information for a small polling app. The app is a classic pick up to x of 10 items from the checkboxlist. So there is no fixed number of items.
ie: Pick up to 3 colors you like
The applications writes the choices in a comma delimited field ie
Date | Name | Choices
01/27/1999 | John Smith | Red,Blue
01/28/1999 | Jane Doe | Green, Orange, Pink
1/29/1999 | Bob Jones| Blue
I'm Trying to write a query that will sum the each of the options.
Choice | Total
Red | 22
Blue | 44
Pink | 77
Any help would be appreciated.