yes, it is right had to created temp table on that server first and then insert into it from linkserver.

Thank you.

Thank you again, accept your idea to create #tablename.

when I run this for testing

the message result show as below and it create temptable...

Oh sorry..

I'm running it on sql2000.

but, when I run on sql2008

got error : 'Linkserver' is not configured for RPC.

Think my DBA need to do something configure on linkserver.

May I...

Thank you Gianluca Sartori.

when i run this

got error : Incorrect syntax near 'AT'.

Thank you so much, the query work fine with your help. 🙂

But, my idiot wrong logic doesn't make result come out what I want.