checking whether a stored procedure returns anything

Question

Viewing 3 posts - 31 through 32 (of 32 total)

You must be logged in to reply to this topic. Login to reply

Paul_J Hall of Fame Points: 3698 More actions · Answer 1

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?

Paul_J Hall of Fame Points: 3698 More actions · Answer 2

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.

Jambu Krishnamurthy SSCrazy Points: 2054 More actions · Answer 3

pl see if table valued functions could help:

create function f1()

returns @t1 table(f1 int)

with schemabinding

as

begin

insert into @t1 select f1 from dbo.t1

return

end

select count(*) from f1()