Compare records between table

  • I have one table test where million of records.

    The table is not having any primary column.

    The columns in table are positionid,ID1,ID2,Event,DrC,Acct,Amount,

    valuedate, and Ccyt.

    There are lot of records for valuedate= 20070731 and 20070724. There are other valuedate also.

    But i want to fetch all the different records except valuedate for these two value date (20070731 and 20070724) in table.

    Please provide me query. I am using sql server 2005.

  • All replies should go here

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

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

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