title: T-SQL Column values count
body: <p>Say I have a table A and it has 5 columns (Column1, Column2.. Column5), the values in each column is one char size and stored only
  as alphabetic as follows</p>
  
  <pre>
  
      ID Column1 Column2 Column3 Column4 Column5
      1   A        C       D        A      B
      2   A        D       A        B      A
      3   B        K       Q        C      Q
      4   A        K       E        E      B
      5   F        K       F        F      S
  
  
  </pre>
  
  <p>I need a count of each different value stored in column1 to column5, I want the following information</p>
  
  <pre>
  
       Column1 has A's count=3, B's count=1, F's count=1
       Column2 has C's count=1, D's count=1, K's count=3
  
       and so on
  
  
  </pre>
  
  <p>What is the correct way and format to return these values?</p>
  
  <p>Thanks</p>