Seeking help writing a sql query to locate a technician record (using technicianid equals 47105) and changing the technician name from "Monkey, Puppy" to "Shoop, Brian".
Hi. I would like all historical tickets and notes associated with technician by ID 47105 to come up in incident reports with the tech named Shoop, Brian". Currently the history is reporting them as "Monkey, Puppy".
The ID for Monkey, Puppy is an inactive technician account.
The ID for Monkey, Puppy is an inactive technician account.
I have validated the technicianid 47105 has the technician name Monkey, Puppy.
I would like issue a SQL command that will locate the ID and rename Monkey, Puppy to a valid technician name (Shoop, Brian).
I appreciate your help.