I'm running sql server 2005 and I need to pull information from 2 of the databases(all from the same server). All of the databases are identical minus the data.
database1 = LCDEL
database2 = LCDFV
I need all of the location data from each database and instead of querying them one by one. I would like to use the openrowset function but I cannot seem to figure it out.
Because then I could toss the data into a temp table and run my analysis instead of using excel.