title: Issues witht the bcp command when using variables
body: <p>The bcp commnad below gives NO errors</p>
  
  <pre><code>exec master..xp_cmdshell 'bcp "select RecordType + PaymentYear from   CentersApp.dbo.IRS_TRecord"     
  queryout "\\w2k3solomon\c$\IRS1099B\IRS_VENDORS.TXT"  -T -c -S SOLOMON'
  </code></pre>
  
  <p>However, when I use variables to do the same thing (see below), I am getting the error <strong><code>'bcp' is not recognized as an internal or external command</code></strong></p>
  
  <pre><code>  declare @t nvarchar(200)
    declare @s nvarchar(1000)
  
  
     set @t = '"select RecordType + PaymentYear from CentersApp.dbo.IRS_TRecord"'
     set @s =  '''bcp ' + '"' +  @t + '"' +  '        queryout "\\w2k3solomon\c$\IRS1099B\IRS_VENDORS.TXT"  -T -c -S SOLOMON '''
  
     exec master..xp_cmdshell @s
  </code></pre>