Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
osupratt
Posting Yak Master
238 Posts |
 Posted - 2008-11-17 : 11:40:52
|
| I need to run a query that will join data from different servers. The applications are different. Applications are accounting software, but are not the same. I work for a corporate office where we have 10 different companies where some use one software package and others use another package. I need to get Sales totals from Customers from all companies and join them together. I don't know if I need to add link servers and then ensure column names match? Any initial help on how I should approach this mess would be of great help. Thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-17 : 12:15:47
|
| use either linked server approach or use OPENROWSET. Bokks online has details about both |
 |
|
|
osupratt
Posting Yak Master
238 Posts |
Posted - 2008-11-17 : 12:24:37
|
| OPENROWSET OR OPENDATASOURCE? This is something that will be used quite often, possibly daily. Is there one method better than the other? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-17 : 12:32:19
|
| OPENROWSET is mostly used for adhoc access. it doesnt require establishing a lined server connection with remote server.See books online for detailshttp://msdn.microsoft.com/en-us/library/ms190312.aspxhttp://msdn.microsoft.com/en-us/library/ms179856(SQL.90).aspx |
|
|
|
|
|
|
gather data from different servers