title: How to concatenate Int variable in the SQL Select Query
body: <p>I have to write a select query with concatenating the stored procedure Exec in the select results.</p>
  
  <p>This is the actual stored procedure execution result</p>
  
  <pre><code>exec wf_Move_bills ''' + billid+ ''',361,14098,14100, ''+ binid +'' ,''' + @comment + ''' 
  </code></pre>
  
  <p><code>BinId</code> is an Integer. I am having trouble on concatenating with my query.</p>
  
  <p>Result is returned as: </p>
  
  <pre><code>exec wf_Move_bills 'XZ242344',361,14098,14100, '+ binid +' ,'Moved by Dev :' 
  </code></pre>
  
  <p>Expected result is:</p>
  
  <pre><code>exec wf_Move_bills 'XZ242344',361,14098,14100, 300 ,'Moved by Dev :' 
  </code></pre>
  
  <p>Because in the stored procedure, parameter for <code>binid</code> is <code>int</code> with length = 4</p>
  
  <pre><code>declare @comment nvarchar(4000) 
  set @comment= 'Moved by Dev:'
  
  select 
      *,
      'exec wf_Move_bills ''' + billid+ ''',361,14098,14144, ''+ binid +'' ,''' + @comment + ''' '
  from 
      billingtable
  </code></pre>