title: simple SQL Pivot Query
body: <p>I apologize for my ignorance. I just am not familiar with pivot queries AT ALL and all the examples I find seem about as clear as mud. I have table that returns GroupName and ID Numbers.  </p>
  
  <p>For Example:</p>
  
  <pre><code>SELECT GroupName, IDnumber FROM do.Table_1
  </code></pre>
  
  <p>Returns</p>
  
  <pre><code>GroupName                IDnumber
  1                          8395
  1                          A660
  1                          8396
  1                          A661
  2                          8398
  2                          A662
  2                          8399
  </code></pre>
  
  <p>What I want is something more like this:</p>
  
  <pre><code>GroupName              ID1     ID2   ID3   ID4
  1                      8395   A660  8396   A661
  2                      8398   A662  8399   NULL
  </code></pre>
  
  <p>How can I do this? Pivot query? Some other method?</p>
  
  <p>I am open to suggestion and appreciate any help you could provide.</p>