Right Rolf,

I agree to your arguments and even i liked the way you created the temp table and the whole process. Now i see what exactly you were looking for....

Listen rolf.

When you are creating a dynamic sql with the orderid and all other stuff getting concatinated, please do something like this and try, you can see in the below...

Rolf,

As i mentioned earlier that OpenQuery wont accept variables, why dont you give a try creating a dynamic query with your OrderId getting concatinated to a string stored in a...

OPENQUERY does not accept variables for its arguments