Hi. Thank you for your answer.
I enabled debugging and the quotes seem to go through to the database ('select
ID ...'):
select * from openquery(LINKED_SERVER,
'select ID from REMOTE_TABLE
where NAME in( ?, ?)
') RT
left outer join LOCAL_TABLE LT on (RT.ID = LT.ID)
I am guessing there is indeed a problem with the quotes, but rather when the
parameter list gets applied (?, ? ) and I don't know if CDATA would help then.
Please let me know if I misunderstood your observation.
Alin
________________________________
From: Nicholoz Koka Kiknadze [mailto:[EMAIL PROTECTED]
Sent: Monday, October 06, 2008 3:33 PM
To: [email protected]
Subject: Re: linked server with list parameter
Should not you use CDATA sections to get quotation marks intact in your SQL ?
And like Jeff pointed out, look at the generated statements in your log
