Untitled

UPDATE C3_Stats2 AS s

SET SLA_Initial_Contact_CCO_ID = (
	SELECT 
		t1.SR_Number,
		t1.SLA_Initial_Contact_CCO_ID
	 FROM (
		SELECT
			s.SR_Number, 
			SR_Activity_User_CCO_ID AS SLA_Initial_Contact_CCO_ID
		FROM 
			C3_Stats2 s
			JOIN ( 
				SELECT 
					MIN(SR_Activity_Timestamp),
					SR_Number,
					SR_Activity_User_Workgroup,
					SR_Activity_User_CCO_ID
			FROM
				C3_Notes
			WHERE
				SR_Activity_Code = '9200'
			GROUP BY
				SR_Number
		) t1 ON s.SR_Number = t1.SR_Number
		WHERE
			SLA_Initial_Contact_CCO_ID = 'XXCTS_SRM_ADMIN_PROCESS'
	) t1 
	WHERE s.SR_Number = t1.SR_Number
	);