title: Pass select result as parameter of stored procedure
body: <p>I have a T-SQL stored procedure with the following parameters</p>
  
  <pre><code>CREATE PROCEDURE [dbo].[SaveData]
  -- Add the parameters for the stored procedure here
      @UserID varchar(50),
      @ServiceID varchar(50),
      @param1 varchar(50),
      @param2 varchar(50),
      @endDate datetime
  AS BEGIN
      . 
      .
      -- my code --
  </code></pre>
  
  <p>I want know if it is possible to pass a result of <code>select</code> as parameter:</p>
  
  <pre><code>    exec SaveDate (SELECT player.UserID,player.ServiceID, 'no','no',GETDATE()
             FROM player)
  </code></pre>
  
  <p>I tried something like this, but it does not work.</p>