title: Select a column returned by a stored procedure
body: <p>I have a stored procedure which is returning me about 50 columns. I want to write a query, where I will be able to select a particular column from the list of column returned by the SP.</p>
  
  <p>I tried writing <code>select RSA_ID from exec(uspRisksEditSelect '1')</code> But Its throwing me an error.
  I think we need to write some dynamic sql for it. But I am new to it.</p>