title: Inserting multiple select statements into a table as values
body: <p>Is it possible to do something like this in SQL Server:</p>
  
  <pre><code>INSERT INTO MyTable (Col1,Col2,Col3,Col4,Col5,Col6,Col7) VALUES
  
  SELECT Col1 FROM Func1(),
  
  SELECT Col2 FROM Func2(),
  
  SELECT Col3,Col4,Col5 FROM Func3(),
  
  SELECT Col6 FROM Func4(),
  
  SELECT Col7 FROM Func5()
  </code></pre>
  
  <p>I have a large number of functions which return one-value results and one function which returns 3 columns. I would like to insert all of this data into one row of a table?</p>
  
  <p>I can see the function returning muliple columns as possibly being a problem?</p>