Retrive records form same table in different databases

  • Hi guys,

    I hv same table say "Patient" in 2 different databases that are present on different or same server, Now i want to get those different records from the "Patient" table that are present in these databases.

    Does anyone have any stored procedure or a SQL query that will solve my above problem.

    I need it urgently.......

    thanks,

    Sagar

  • Please do not cross post. You only need to post your question in one forum!! Continue this thread here:

    http://qa.sqlservercentral.com/Forums/Topic422446-8-1.aspx

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

Viewing 2 posts - 1 through 1 (of 1 total)

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