Post reply

Compare records between table

  • September 18, 2009 at 1:38 am

    #98111

    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.

  • September 18, 2009 at 1:53 am

    #1055410

    SELECT *

    FROM

    WHERE valuedate '20070731'

    and valuedate '20070724'

    -- Gianluca Sartori

  • September 18, 2009 at 2:05 am

    #1055413

    SELECT *

    FROM

    WHERE valuedate '20070731'

    and valuedate '20070724'

    -- Gianluca Sartori

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

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