title: How can I use pivot to find the records with the most columns populated?
body: <p>I have a problem where I have 5 columns.</p>
  <p><a href="https://i.stack.imgur.com/FCzf7.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/FCzf7.png" alt="enter image description here" /></a></p>
  <p>What I want to do is add a count on the end with the number of columns where there is no null value.</p>
  <p>I am trying to use pivot as this seems to be the most logical SQL clause. Any ideas on this? I haven't used Pivot in many instances so this is new for me.</p>