I have a table with the below data for example,
|ABC123||MR Sunil||40.00 x 12.00||CS1||1|
|ABC123||MR Sunil||50.00 x 15.00||CS2||Transferred||2|
|ABC124||MR Sunil||30.00 x 10.00||CS3||1|
I have a below table and I got the Row_Number over partitioning by USER_NO.
In the Re-RUN column of SALE_ID CS2 , I want to have the value as CS1 – because they both have the same USER_NO and the Reason_cancelled is present for SALE_NO CS2.
The cross apply i snot working for update. Can you please let me know how to do it ?