The table structure is like this; Table - 1 PROCESS_DATE CLEARING_DATE BATCH_NO SLIP_NO DOC_TYPE CHEQUE_NO UNIQUE_IDENTIFIER 2020-02-22 2020-02-25 7135001-000850 1 3 251088 2020022571350010008500001 2020-02-22 2020-02-25 7135001-000850 1 3 012057 2020022571350010008500002 2020-02-22 2020-02-25 7135001-000850 1 3 000093 2020022571350010008500003 2020-02-22 2020-02-25 7135001-000850 1 3 389389 2020022571350010008500004 2020-02-22 2020-02-25 7135001-000850 1 3 679492 2020022571350010008500005 2020-02-22 2020-02-25 7135001-000850 2 3 389323 2020022571350010008500006 2020-02-22 2020-02-25 7135001-000850 2 3 012062 2020022571350010008500007 2020-02-22 2020-02-25 7135001-000850 2 3 679504 2020022571350010008500008 2020-02-23 2020-02-25 7135001-000850 2 3 389323 2020022571350010008500006 2020-02-23 2020-02-25 7135001-000850 2 3 012062 2020022571350010008500007 Table - 2 PROCESS_DATE CLEARING_DATE BATCH_NO SLIP_NO DOC_TYPE CHEQUE_NO UNIQUE_IDENTIFIER 2020-02-22 NULL 7135001-000850 1 2 NULL 2020022271350010008500001 2020-02-22 NULL 7135001-000850 2 2 NULL 2020022271350010008500002 2020-02-23 NULL 7135001-000850 2 2 NULL 2020022371350010008500002 2020-02-25 NULL 7135001-000850 1 2 NULL 2020022571350010008500001 2020-02-25 NULL 7135001-000850 2 2 NULL 2020022571350010008500002
Out put i need PROCESS_DATE CLEARING_DATE BATCH_NO SLIP_NO DOC_TYPE CHEQUE_NO UNIQUE_IDENTIFIER 2020-02-22 NULL 7135001-000850 1 2 NULL 2020022271350010008500001 2020-02-22 2020-02-25 7135001-000850 1 3 251088 2020022571350010008500001 2020-02-22 2020-02-25 7135001-000850 1 3 012057 2020022571350010008500002 2020-02-22 2020-02-25 7135001-000850 1 3 000093 2020022571350010008500003 2020-02-22 2020-02-25 7135001-000850 1 3 389389 2020022571350010008500004 2020-02-22 2020-02-25 7135001-000850 1 3 679492 2020022571350010008500005 2020-02-22 NULL 7135001-000850 2 2 NULL 2020022271350010008500002 2020-02-22 2020-02-25 7135001-000850 2 3 389323 2020022571350010008500006 2020-02-22 2020-02-25 7135001-000850 2 3 012062 2020022571350010008500007 2020-02-22 2020-02-25 7135001-000850 2 3 679504 2020022571350010008500008 2020-02-23 NULL 7135001-000850 2 2 NULL 2020022371350010008500002 2020-02-23 2020-02-25 7135001-000850 2 3 389323 2020022571350010008500006 2020-02-23 2020-02-25 7135001-000850 2 3 012062 2020022571350010008500007
Is there any way to achieve this in SQL? it's urgent. Any help is really appreciated. Thank You.
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)