title: get count of columns that have a -1, 0, 1, 2 values for a single row
body: <p>Using SQL Server, I need to get a column count that has -1, 0, 1, 2 for its values for each row.   There are different number of columns per table (one table has 55 fields)</p>
  
  <pre><code>-1 value = no answer or unknown (unknown_count)
  0  value = ok (ok_count)
  1  value = bad  (bad_count)
  2  value = not applicable  (na_count)
  </code></pre>
  
  <p>row 1 looks like this     </p>
  
  <pre><code>rowid        name       field_1       field_2     field_3  field_4
  1            line_1     -1            1           2        1
  2            line_2     2             1           -1       0
  </code></pre>
  
  <p>etc...</p>
  
  <p>Results i would like to see</p>
  
  <pre><code>rowid     na_count     ok_count     bad_count     unknown_count
  1         1            0            2             1
  2         1            1            1             1
  </code></pre>
  
  <p>Extra credit question....   i need to get a count of all the fields that are used to build the counts (so i can give a percentile report)</p>