Post reply

Sql to update active row

  • November 21, 2019 at 6:53 am

    #3699463

    I have below two tables

    EMpbasetable:

    Skey,EmployeeNumber,Startdate,EndDate,Active

    3,123,2019/06/10,2019/10/27,0

    4,123,2019/10/28,4712/12/31,1

    EmpIncTable:

    Skey,EmployeeNumber,Startdate,EndDate

    9,123,2019/06/10,2019/10/17

    10,123,2019/10/18,4712/12/31

    My requirement is skey 9,10 insert in EMpbasetable table and 3,4 active indicator should changed to 2. Skey 9 to 0 and 10 change to 1

    3,123,2019/06/10,2019/10/27,2

    4,123,2019/10/28,4712/12/31,2

    9,123,2019/06/10,2019/10/17,0

    10,123,2019/10/18,4712/12/31,1

    • This topic was modified 5 years, 7 months ago by selpoivre.

  • November 21, 2019 at 2:21 pm

    #3699639

    When there no uncommitted transactions do the EMpbasetable and  EmpIncTable have the same number of rows?

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

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

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