Hall of Fame
December 28, 2006 at 7:14 pm
Sorry I dont understand what you mean.
The data I need to get comes from Server1.DB1 (e.g. employee name, address, phone) and Server2.DB2 (e.g. salary, DOB).
Where should I create the VIEW and SP?
December 28, 2006 at 7:19 pm
Nevermind, got it. Added the link server retrieval stuff into the SELECT list in the view and it's all working fine.
Thanks for all your help.
December 29, 2006 at 8:09 am
pl see if table valued functions could help:
create function f1()
returns @t1 table(f1 int)
insert into @t1 select f1 from dbo.t1
select count(*) from f1()
Viewing 3 posts - 31 through 33 (of 33 total)
You must be logged in to reply to this topic. Login to reply