Timeline for Update data of one table from another with comparing columns have same initial strings
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 1, 2016 at 6:40 | comment | added | Gaurava Agarwal | @Phil, I got extended version of your solution. | |
| Jun 30, 2016 at 13:12 | comment | added | ypercubeᵀᴹ |
@Phil, I suggest you add a (huge, bold) notice that for all rows of table OldData that the ename does not appear in table NewData, the job and sal will be updated to NULL.
|
|
| Jun 30, 2016 at 12:43 | comment | added | Yuvraj | Actually, my OldData have pattern for Ename as 'Name.domain.com' for all records but in NewData, Ename column have some records just names and some as 'Name.domain.com' So, Its hard to compare b.Ename = a.Ename. | |
| Jun 30, 2016 at 12:35 | review | Low quality posts | |||
| Jun 30, 2016 at 14:36 | |||||
| Jun 30, 2016 at 12:16 | history | answered | Philᵀᴹ | CC BY-SA 3.0 |