title: How to combine multiple rows into one row for a field in MS SQL 2008 R2 without using temp table or variable?
body: <p>How do I accomplish my goal without using temp table or variable?</p>
  
  <p>Table:</p>
  
  <pre><code>ID    ModelNum   Qty
  123   ABC         4
  123   DEF         4
  </code></pre>
  
  <p>Expected Result:</p>
  
  <pre><code>ID    Models       Qty
  123   ABC | DEF    4 
  </code></pre>
  
  <p>Thanks in advance!</p>