sql server replication: I'm investigating replication or DTS as a possible solution to my
problem. I'm looking to replicate data from one server to another,
I want all of the columns of one table PLUS another column from
another table to transfer to the other server.

For example on Server A, I have a table foo. Table Foo has column1
and column2. Also on Server A I have a table bar. Table bar has a
column1 and a column3. Server B has a table called test which has
column1, column2 and column3.

I want to replicate to the test table on Server B,
foo.column1, foo.column2, bar.column3
where foo.column1 = bar.column1

Is this possible?

I looked into replicating a view, but this requires the underlying
tables to reside at the subscriber which I do not want.

Can you replicate the output of a stored procedure to another
server? I see references to replicating stored procedures, but can't
figure out how to implement this. The only options I have for
articles are Tables and Views, why don't I see any stored procedures
as articles to publish??

Maybe it makes more sense just to use DTS?

You could investigate indexed views for this.
Regards,
Paul Ibison

Here is an example of how to do it

http://216.239.41.104/search?q=cache:v5nnQ9YzYVkJ:www.dbforums.com/archive/index.php/t-966010.html+sp_addarticle+hilary+creation_script+&hl=e

Looking for a SQL Server replication book