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)
 Creating a text file with alternate records from 2 tables

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-12-14 : 08:12:09
rajeesh writes "Hi,
Here is the fun...I have to create a text file from the records of 2 tables say table A and B. I have to pick one record from table A and the next 5 from table B.The order has to be maintained. The relationship between table A and B is One-to-many. For every entry in the table A, there are 5 corresponding entries in table B. Please let me know if you have any questions.
Any help would be greatly appreciated.

Cheers!!!"
   

- Advertisement -