I found the solution myself.  You need to use the following format:

SELECT     *

FROM         OPENQUERY(workshop, 'SELECT * FROM prodcl') Rowset_1

By adding the OPENQUERY you...

Here's another approach.  Take a lesson from the VFP world if the total record lenght is not too great.

Create view server1.dbo.View1 as Select key1, key+col1+col2+col3+col4 as compare1 from server1.dbo.table1

go

Create view server2.dbo.View...

I tried the "SELECT * FROM dbo.TheFunction()"  approach and can never get it to work.  I get an "Invalid object name" error.  I know that the object is valid because...

Assuming that you have already varified that the data types you are inserting match the data types you are selecting, here is the solution I used when I had this...