hi,
Is it possible to to write a SQL stored procedure which accesss two databases residing on different servers and joins the data within them. If so how? I've been tasked with writing a number of procs to do just this and i can't see a way to do it without temporarily creating the necessary tables from one database within the other. X-)
Is it possible to to write a SQL stored procedure which accesss two databases residing on different servers and joins the data within them. If so how? I've been tasked with writing a number of procs to do just this and i can't see a way to do it without temporarily creating the necessary tables from one database within the other. X-)