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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Store Procedure

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-01-07 : 08:53:31
sandip writes "1)i have 1 empty database which is created from old one,
from old master table i have to carry some specific record to new databse master . at that time old master can have some data in soem details table if it is present i have to carry it to new data base
i knowe all master and details tables and thier relationship
eq. ApplicationMaster in old master has caseId 3 then i have to carry details from ApplicarionCase_3 table to new database
===============================================================
2)i want recordset of 4 field from 12 tables which is not related
some table can have data some cannot have it
from that all table only 1 field is common which is shippingline
and for that shipping line i want record from 12 table
files may be like this
field1,field2,field3,field4 from tabel1
field2,field15,field1,field10 from table 2
field2,filed13,field14,field9 from table 3"
   

- Advertisement -