<div>
you can only do that with dynamic sql, as OPENQUERY does (unfortunately) not allow a variable for the SQL ...
</div>


you can only do that with dynamic sql, as OPENQUERY does (unfortunately) not allow a variable for the SQL ...

<div>
could you give an example? 
</div>


<div>
Perfect example, it was the quote &quot;hell of quotes&quot; I was having trouble with.
</div>


Perfect example, it was the quote "hell of quotes" I was having trouble with.

<div>
<div class="content wysiwyg-content">
Hello experts,<br />
<br />
I would like to pass a variable in a linked server query. I am using MSSQL 2008 SQL server management studio.<br />
<br />
I am querying a linked server running a Progress database<br />
<br />
This query works <br />
<br />
select count('order') as 'Orders Entered' from Openquery(V2, 'select order from oe_head where ord_date = ''12/28/2009'' and company_oe = ''cc'' and rec_type = ''o''')<br />
<br />
I would like to pass a variable DATE for the ord_date but can't seem to get the syntax correct<br />
<br />
Any ideas?<br />
<br />

</div>
</div>


Hello experts,

I would like to pass a variable in a linked server query. I am using MSSQL 2008 SQL server management studio.

I am querying a linked server running a Progress database

This query works 

select count('order') as 'Orders Entered' from Openquery(V2, 'select order from oe_head where ord_date = ''12/28/2009'' and company_oe = ''cc'' and rec_type = ''o''')

I would like to pass a variable DATE for the ord_date but can't seem to get the syntax correct

Any ideas?



How do I pass a variable in a MSSQL linked server query?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.