title: SQL Server: Count number across columns
body: <p>Im looking for assistance with what I thought was a simple task. :(</p>
  
  <p>I have a table in SQL Server instance that contains the following columns and data:</p>
  
  <pre><code>num1   num2   num3   num4   num5
  1      34     15     22     45
  23     4      2      100    23
  1      23     23     100    5
  </code></pre>
  
  <p>I want to get results that count the number of time all numbers appear:</p>
  
  <pre><code>Number  Count
  1       2
  2       2
  3       0
  4       1
  5       1
  6       0
  </code></pre>