Archiving problem

• DANGERMOUSE275

  Grasshopper

  Points: 19

  More actions

  August 29, 2003 at 3:40 am

  #106331

  Hi,

  I want to create an archiving databse.

  I have created the database + tables = easy enough

  I have copied a table called GL_POSINGS from db1 to the archive databse with YEAR=2002. Next I need to copy GL_TRANSACTIONS from db1 into the archive database where the JOURNAL_NO field exists in the archived databse - HELP, this is just too hard

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  August 29, 2003 at 7:35 am

  #471982

  select * from db1.dbo.GL_TRANSACTIONS

  where JOURNAL_NO IN (select JOURNAL_NO from archivedb.dbo.GL_POSINGS)