title: SQL Split Single Row into Fixed Number of Columns
body: <p>We need to split a single row into fixed number of multiple columns. Following is an example for the data set:</p>
  
  <ul>
  <li>1</li>
  <li>2</li>
  <li>3</li>
  <li>4</li>
  <li>5</li>
  <li>6</li>
  <li>7</li>
  </ul>
  
  <p>Desired Output:</p>
  
  <pre><code>Column A        Column B       Column C      Column D
  1                  2              3              4
  5                  6              7             NULL
  </code></pre>
  
  <p>Thanks for your help in advance.</p>