November 21, 2019 at 6:53 am
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
November 21, 2019 at 2:21 pm
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy