hello, this is my first time posting here and I hope someone can help me. First, let me say that I am NO SQL Guru and this one has me stumped.

I have a table that stores the results of customer surveys and am tasked with displaying graphs of the results in an ASP.Net web page. I am trying to write a query for an sProc that will return a data table with the summaries data. The table looks something like this:

SurveyID Q1 Q2 Q3 Q4 Q5 HE1 HE2 HE3 HE4 HE5
2 2 2 2 2 2 2 2 2 2 2
3 1 3 1 3 1 1 2 3 4 5
4 0 0 0 0 0 0 0 0 0 0
7 3 0 0 0 0 0 0 0 0 0
8 4 4 2 4 2 3 3 3 3 3
9 1 2 2 3 1 2 2 2 2 2
10 2 2 2 2 2 1 1 1 1 1

What I would like to return would be a data table that would summarize the counts of each value (0 to 4) in each column like:

Q1 Q2 Q3 Q4 ... etc
1 2 2 2
2 0 1 0
1 3 4 1
1 1 0 2
1 1 0 1

Of course, the rows represent the values 0,1,2,3,4

Is this possible? I have experienced abject failure with everything I have tried! Thank you in advance for your help.