Timeline for Update data of one table from another with comparing columns have same initial strings
Current License: CC BY-SA 3.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 1, 2016 at 8:20 | comment | added | BriteSponge | @Guarava - as per the answer you based this on you will end up updating columns 'job' and 'sal' to null for any records in olddata that are not in newdata. However I don't like lots of string operations nested either and the (a.EName like b.EName||'.%') works much better. | |
| Jul 1, 2016 at 6:23 | history | edited | Gaurava Agarwal | CC BY-SA 3.0 |
improved formatting
|
| Jul 1, 2016 at 6:13 | history | answered | Gaurava Agarwal | CC BY-SA 3.0 |