Hi Lowell,

Nope I didn't get a comma separated list. and ordernumber is a varchar(20).

My main server is SQL 2000 and the instruction FOR XML PATH.. is not available.

I tried using...

Hi Lowell,

Thanks a lot for your explanation about what i was trying to do.

You were right, delimiting the query to the linked server using a subselect worked perfectly. Less...