+ 1

SQL PROCEDURE

FACILTY facno status 222222 A 333333 C 44444 A 555555 C pdcheq PDCHQ NO FACNO 556 222222 223 222222 223 222222 2236 333333 223 333333 556 333333 55 4444 22 55555 33 55555 66 55555 55 55555 99 55555 if facno Active STATUS (A) PDCHQ STATUS NEED TO BE "C" IN NEW COLUM HOW TO BUILD SQL PROCEDURE PLEASE HELP FRIENDS

17th Apr 2018, 9:56 AM
Amila Darshana
Amila Darshana - avatar
1 Answer
0
Is there duplication in the table, such as row 2 and 3 in PDCHQNO, or was that in error?
12th May 2018, 8:36 AM
SQrL
SQrL - avatar