Post reply

How to get the new records in SQL 2005

  • October 9, 2010 at 12:19 pm

    #239508

    I want to use an iSeries file that has transactions. This file is added to by the COre OS 24X7.

    I can download this file into a SQL Table. I process these transactions and place them in a Sent file.

    The next time I download the iSeries file, I want a query to give me the results of records I haven't processed (the newest transactions).

    How can I bump these two files to determine the new records?

    Jim

  • October 9, 2010 at 12:38 pm

    #1234640

    Table definitions and some sample data would help.

    You need either some column or set of columns that are unique, or a transaction date to be able to do this.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply