I have to insert a record in a table like this script:
insert into Notes (name, surname, dateref, UserNote)
values ('Bob', 'Fedd', GETDATE(), 'Double questionarie');
but if is already present a record for these "name" and "surname",
I have to append the string 'Double questionarie'
to the already present value in the UserNote field.
How can I accomplish this task?
Thanks a lot in advance.
I'm using SQL Server 2008 R2, so some features are not available.