title: Get a single parent with all children in a single row
body: <p>Let's asume I have a parent-child structure setup in SQL (server 2005):</p>
  
  <pre><code>CREATE TABLE parent (Id INT IDENTITY PRIMARY KEY, Name VARCHAR(255))
  CREATE TABLE child (Id INT IDENTITY PRIMARY KEY, parentId INT, Name VARCHAR(255))
  
  insert into parent select 'parent with 1 child'
  insert into parent select 'parent with 2 children'
  
  insert into child(name, parentid) select 'single child of parent 1', 1
  insert into child(name, parentid) select 'child 1 of 2 of parent 2', 2
  insert into child(name, parentid) select 'child 2 of 2 of parent 2', 2
  </code></pre>
  
  <p>Is there a way to return one row per parent with it's children as columns? Like:</p>
  
  <p>parent.Id, parent.Name, child(1).Id, child(1).Name, child(2).Id, child(2).Name</p>
  
  <p>Started out with:</p>
  
  <pre><code>select * from parent p
      left outer join child c1 on c1.parentid = p.id
  </code></pre>