Passing sql parameter to openquery's query

Question

I have following SQL query in SQL Server 2008

Select * from
    (Select T.Col1, T.Col2 
     from openquery('server','select * from table 1 where date= '+ @StartDate +') R

Where @StartDate is a parameter. I get an error that incorrect syntax near '+' expecting ')'

Answer 1

This is a duplicate post.

The short answer is OPENQUERY does not accept variables for its arguments. See: including parameters in OPENQUERY for a possible workaround.