here is the solution ;
for example
SQL Server Name in US is USSERVER
SQL Server Name in CANADA is CANADASERVER
1-)from Client Network Utilty add servers
2-)in a SQL Query sentence write down
the server name(called in Client Network Utilty )
which you want to add .
'SP_addlinkedserver...
You can create a view under SQL Server.After that, you can add it to your report and use it like the other tables.
View 's sql statement =
"select db2.Symbols.symbol as symbol , db1.Accounts.NumberShares * db2.Symbols.Price as value
from db1.Accounts,db2.Symbols
where db1.Accounts.symbol...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.