As if, that request wasn’t hard enough – the client sent over some bad data and would like us to clean it up. If we encounter the STATE field as ‘YN’ we should rename it ‘NY’ within this view.
Assume that the records shown in our example on page 2 and 3 are just the first rows of the table. There are more groups and states than are displayed in the sample. The table has an upper-based functional index on CUSTOMER_ID, PRODUCT_ID, EMAIL_ADDRESS, GROUP and STATE
What I have tried:
I try to solve it by store procedure
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)