title: TSQL stored procedure result as column in another select
body: <p>I have a stored procedure with input and output parameter.</p>
  
  <pre><code>CREATE PROC [dbo].[pr_MySP]
      @date DATETIME,
      @usd MONEY OUTPUT
  WITH ENCRYPTION
  AS
  BEGIN
      ...
  END
  GO
  </code></pre>
  
  <p>This stored procedure call another stored procedures, so I can't create UDF to do it. And now I need to use this proc result as column in another select. Somethin like this</p>
  
  <pre><code>select *, ([dbo].[pr_MySP] result) from ... 
  </code></pre>
  
  <p>Is there any way to do this?</p>