title: Conversion failed when converting varchar value to int
body: <p>I am getting error while trying to execute the SP. pls help</p>
  
  <pre><code>Conversion failed when converting the varchar value 'INSERT INTO INVESTOR_ACCOUNT     VALUES('253361',' to data type int.
  </code></pre>
  
  <p>This is my SP</p>
  
  <pre><code>ALTER Procedure [dbo].[RM_INVESTOR_ACCOUNTS_INSERT]
  @AccountNo varchar(20), @InvestorID integer, @SaleDate datetime
  As
  Begin
  declare @query nvarchar(max) 
  set @query ='INSERT INTO INVESTOR_ACCOUNT VALUES('''+ @AccountNo+ ''','+@InvestorID+','+@SaleDate+ ')'
  print @query
  End
  </code></pre>
  
  <p>Executed with below command </p>
  
  <pre><code>exec RM_INVESTOR_ACCOUNTS_INSERT '253361',1,'2003-12-24 00:00:00.000'
  </code></pre>