sql - Multiple Server Query -
good morning experts.
i need on report trying create. far have it, way can work create 2 separate reports , merge them in excel. , takes lot or work , time excel prepare calculations. report pipeline report our suppliers specific manufacturers. using 2 queries 2 different servers.
query 1. products on "opportunities". list part number, cost , sell.
query 2. products supplier databases. pull manufacturers care about. list part number, manufacturer name , list. have modify manufacturer name consistent. example cisco can "cisco software", "cisco hardware", "cisco license", need cisco. take care of case statement. want report base on list price. query can have 200k lines.
in excel bring both queries , vlookup match part number , bring manufacturer , list price. can pivot.
i using tsql build query.
to in 1 query, need setup linked server. check dba @ company see if willing setup or if have admin access these servers can set (here information on setting linked server sql server 2008. once done use 4 part naming reference different servers, databases , table, , join on part number , work rest of magic.
the key getting linked server setup can reference supplier database other 1 in single query. option use sql server integration services join 2 data sets.
it if posted 2 queries.
Comments
Post a Comment