No, you can't do that. The stored procedure will have to
be recreated as aview or the stored procedure can dump the
data into a permanent table that can then be used in the
view. The other way is to join the two tables in the
server on the Sql>-----Original Message-----
>We have a Lotus Notes server. I have set up a linkedthere, I have>server that connects to the 'table' in lotus notes. Fromtable.>created a stored procedure that pulls data from thata SQL table with>
>All that is running great.
>But now, I want to have a view that joins the content ofto join a table with>the content of the stored procedure. In essence, I wantdoing wrong? thank>a stored procedure. Is that possible? if not, what am I>you.