How to create a new row in one table with updated comments fields from another table.
Need experts help ,here is the my requirement.
i have question table which is having 5 fields in that 3 are key columns and 4th is comment column 5th one is time stamp column.
my 4th comment column having comments data (varchar(10000)), in that comment data needs to be replace with matched word from my employee table first name column and replace with replacement word, after entire replacement comment columns needs to populate in another row..!
Search for first name match from employee table , name and replace with " " or “XXX”
Example (flag on 'John'):
‘I had very poor service from John.’
‘I had very poor service from .’ or ‘I had very poor service from XXX.’
‘My flight was excellent. Sincerely, John’
‘My flight was excellent. Sincerely, ‘ or ‘My flight was excellent. Sincerely, XXX’
if i could get the response ASAP, that would be great!!