title: Selecting multiple columns from a subquery
body: <p>I've searched a lot, but still no chance on having a subquery to return multiple columns all at once. The following code works, but it sucks:</p>
  
  <pre><code>SELECT
      (SELECT Column1 FROM dbo.fnGetItemPath(ib.Id)) AS Col1,
      (SELECT Column2 FROM dbo.fnGetItemPath(ib.Id)) AS Col2,
      (SELECT Column3 FROM dbo.fnGetItemPath(ib.Id)) AS Col3
  FROM ItemBase ib
  </code></pre>
  
  <p>I actually have got no idea how to pass ib.Id to the function and get the entire Column1, Column2, Column3 columns without calling the fnGetItemPath function 3 times.</p>
  
  <p>Thanks in advance</p>