Jim,
Thanks a lot for kickstarting me.
I got it to work using the following!
eg. Select * from LinkedServerName...TableName
Your example was close, but just needed the extra period.
You can't imagine how much code that saves me and having to use temp tables.
Very cool.
Thanks,
Joe