I need to create a sequence number on a table. I was using row number logic earlier but it takes forever to update the sequence number as it is huge table and new data is inserted every day. I also tried using the Identity column but the problem is that there is an update through MLOAD and the...
I have 3 tables T375, T378 and T350.
T375 - A1,B1,C1,D1.
the rest of the fields E1,F1 ...etc are not UPI's.
T378 - A1,B1,C1,D1
The rest of the fields E3, F3 are not UPI's and are derived from T375.This table is a child of T375 with the same UPIs.
T350 - A2,B2,C2,D2,E2,F2,G2
The rest of the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.