title: How to create a virtual table in MS SQL
body: <p>I found it easier to explain with musicians than with my actual data. 
  Every Musician has an ID, used for their name and instruments.</p>
  
  <p><code>Select ID, NAME, PARAM FROM TABLE</code></p>
  
  <p><strong>CURRENT RESULT</strong></p>
  
  <pre><code>ID  NAME        PARAM
  911 John        Name  
  911 Guitar      Instr 1  
  911 Piano       Instr 2
  912 Paul        Name 
  912 Bass        Instr 1
  912 Piano       Instr 2
  912 Guitar      Instr 3
  913 Freddie     Name
  913 Piano      Instr 1
  913 Guitar     Instr 2
  914 Brian      Name
  914 Guitar     Instr 1
  </code></pre>
  
  <p>I would like to add a column 'Band' that I would need to create starting from the ID's</p>
  
  <ul>
  <li>BAND = B includes ('911', '912') </li>
  <li>BAND = Q includes ('913', '914')</li>
  </ul>
  
  <p><strong>WANTED RESULT</strong></p>
  
  <pre><code>ID    NAME      PARAM    BAND
  911 John        Name     B
  911 Guitar      Instr 1  B
  911 Piano       Instr 2  B 
  912 Paul        Name     B
  912 Bass        Instr 1  B
  912 Piano       Instr 2  B
  912 Guitar      Instr 3  B
  913 Freddie     Name     Q
  913 Piano      Instr 1  Q
  913 Guitar     Instr 2  Q
  914 Brian      Name     Q
  914 Guitar     Instr 1  Q
  </code></pre>