Hi,
I am trying to join two tables across a linked server while iterating through
a list parameter .
I haven't been able to find the right syntax for this to work.
The below statement is not working:
<statement id="linkedServerWithListParameter" parameterClass="list" resultMap="correctResultMap">
select * from openquery(LINKED_SERVER,
'select ID from REMOTE_TABLE
<dynamic prepend=" where ">
<iterate open=" NAME in(" close=") conjunction=",">
#[]#
</iterate>
</dynamic>
) RT
left outer join LOCAL_TABLE LT on (RT.ID = LT.ID)
<statement>
I tried different combinations of quotes and apostrophes, but it didn't fix it.
Due to my system configuration, "openquery" has to be used for the remote query
(cannot use a four-part name).
Does anyone know how to accomplish this? Any help would be appreciated.
Thank you,
Alin
Texas Tech University
|