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

    as

    begin

     insert into @t1 select f1 from dbo.t1

     return

    end

    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