title: SQL Openquery Dynamic Parameter
body: <p>I am trying to include a parameter in T-SQL's Openquery function. I have done this successfully in the past, but my current code is not cooperating:</p>
  
  <pre><code>declare @bom smalldatetime
  declare @eff_date smalldatetime
  set @eff_date = (select min(postdate) from #temp_all)
  set @bom = convert(varchar(25),dateadd(dd,-(day(@eff_date)-1),@eff_date),101)
  
  select *
  into #temp
  from openquery(db,
  'select l.id
     ,l.date
   from table1 l (nolock)
   inner join table2 m (nolock)
  on l.id = m.id and l.date between m.start_date and m.end_date
   inner join table3 d (nolock)
  on l.param = d.param
   where l.date = ''''' + convert(varchar(10),@bom,101) + '''''
   and m.param1 = ''Y''
   and m.param2 = ''N''
   and param3 is null
   and d.integer &lt; 30
  ')
  </code></pre>
  
  <p>The issue is with the</p>
  
  <pre><code> where l.date = ''''' + convert(varchar(10),@bom,101) + '''''
  </code></pre>
  
  <p>line.  Can someone please tell me what I am doing incorrectly?</p>