title: How to execute a stored procedure inside a select query
body: <pre><code>SELECT col1,
         col2,
         col3,
  
  EXEC GetAIntFromStoredProc(T.col1) AS col4
       FROM Tbl AS T
       WHERE (col2 = @parm) 
  </code></pre>
  
  <p>How to write this SQL query in SQL Server 2008?</p>