checking whether a stored procedure returns anything

  • 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?


  • 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.

  • pl see if table valued functions could help:

    create function f1()

    returns @t1 table(f1 int)

    with schemabinding



     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