title: return two output parameters sp_executesql
body: <p>I have dynamic query I want to get two output parameters from it I used the following code , but the output parameters return null </p>
  
  <pre><code>declare @query nvarchar(max);
  declare @result int; 
  declare @type int
  declare @mainVarcharLength int; 
  
  set @query = 'select   count(*) ,  Type_Code from Customers   WHERE Customers.Cust_Name =  ''CUSTOMER 99''  '
  set @query = @query + '  and Cus_Is_Active = 1  Group BY   Type_Code';
  select  @query
  
  EXEC sp_executesql @query, N'@result int OUTPUT,  @type int OUTPUT', @result,  @type
  
  select @result
  select @type
  </code></pre>
  
  <p>How to solve that , and how to pass multiple output parameters </p>