Calling Two tables, each from different database in one parameterized stored procedure.

• Learner44

  SSCarpal Tunnel

  Points: 4466

  More actions

  May 29, 2013 at 1:07 pm

  #394872

  My Soruce table A is in A1 database and Destincation table B is in A2 database , how I can call them in one stored procedure as in paramater value.

  http://www.sqlservercentral.com/articles/EDW/77100/ , in this it is using two tables from same database , but i want to know how we can use this SP between two database tables.

  Please help me, If someone has any idea.

  Thanks.