Thursday, April 8, 2010

SQL – Openquery (2) Pass Parameters

The syntax for passing parameters is little messy. Here is am example where we pass a date range into the query.

image

Of cause the temp table needs to be created first for the above query to work.

image

No comments:

Post a Comment