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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-06 : 09:01:44
|
| hemant writes "hiI have to database sds_bms/sds_bms@design_dev2And sds_bms1/sds_bms2@design_dev1 I want to select data from both because my report base on to tables one is in first database(sds_bms/sds_bms@design_dev2) and second in second database(sds_bms1/sds_bms2@design_dev1)how do I select the data using sql.rgd,Hemant" |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-03-06 : 09:08:20
|
| you can create a stored procedure which will select the data from your two table's and call that sp to create your report.you can select data from different databases. by following the four part naming conventiosn. servername.databasename.ownername.tablenameeg:select * from east01.fa.dbo.testtableselect * from east01.faprev.dbo.testtableHTH-------------------------------------------------------------- |
 |
|
|
|
|
|
select data