title: Parse text field and join tables
body: <p>I have 2 tables.</p>
  
  <p>Table Heroes - 2 records</p>
  
  <pre><code>Name NVARCHAR(50)
  PowerIds NVARCHAR(50) 
  
  Name               PowerIds
  'Hulk'             '1,3'
  'Reed Richards'    '2'
  </code></pre>
  
  <p>Table Powers - 3 records</p>
  
  <pre><code>PowerId INT
  PowerDescr NVARCHAR(50)
  
  PowerId   PowerDescr
  1         'Strength'
  2         'Intelligence'
  3         'Durability'
  </code></pre>
  
  <p>What would be the smartest way to achieve this in a SELECT:</p>
  
  <pre><code>Name               Powers
  'Hulk'             'Strength, Durability'
  'Reed Richards'    'Intelligence'
  </code></pre>
  
  <p><strong>I cannot change the table structure, since this is a third party product.</strong></p>