UPDATE d
SET d.DAT_Valor = 'PART'
    FROM TESISSEG.dbo.AS_DATOS d
INNER JOIN TESISSEG.dbo.AS_FORMS f ON f.FORM_ID = d.FORM_ID AND f.EmpID = d.EmpID
    INNER JOIN TESISSEG.dbo.AS_CAMPOS c ON c.CAMP_Id = d.CAMP_Id AND d.EmpID = d.EmpID
WHERE f.FORM_Nombre LIKE 'Autos' AND c.CAMP_Nombre LIKE 'uso' AND d.DAT_Valor LIKE 'Particular'


UPDATE d
SET d.DAT_Valor = 'PAEM'
    FROM TESISSEG.dbo.AS_DATOS d
INNER JOIN TESISSEG.dbo.AS_FORMS f ON f.FORM_ID = d.FORM_ID AND f.EmpID = d.EmpID
    INNER JOIN TESISSEG.dbo.AS_CAMPOS c ON c.CAMP_Id = d.CAMP_Id AND d.EmpID = d.EmpID
WHERE f.FORM_Nombre LIKE 'Autos' AND c.CAMP_Nombre LIKE 'uso' AND d.DAT_Valor LIKE 'Empresa'


UPDATE o
SET o.OPC_Valor = 'PART'
    FROM TESISSEG.dbo.AS_OPCIONESCAMPO o
INNER JOIN TESISSEG.dbo.AS_OPCCAMP oc ON oc.OPC_Id = o.OPC_Id AND oc.EmpID = o.EmpID
    INNER JOIN TESISSEG.dbo.AS_CAMPOS c ON c.CAMP_Id = oc.CAMP_Id AND c.EmpID = oc.EmpID
    INNER JOIN TESISSEG.dbo.AS_FORMCAMP af ON af.CAMP_Id = c.CAMP_Id AND af.EmpID = c.EmpID
    INNER JOIN TESISSEG.dbo.AS_FORMS f ON f.FORM_ID = af.FORM_ID AND f.EmpID = af.EmpID
WHERE f.FORM_Nombre LIKE 'Autos' AND c.CAMP_Nombre LIKE 'uso' AND o.OPC_Valor LIKE 'Particular'


UPDATE o
SET o.OPC_Valor = 'PAEM'
    FROM TESISSEG.dbo.AS_OPCIONESCAMPO o
INNER JOIN TESISSEG.dbo.AS_OPCCAMP oc ON oc.OPC_Id = o.OPC_Id AND oc.EmpID = o.EmpID
    INNER JOIN TESISSEG.dbo.AS_CAMPOS c ON c.CAMP_Id = oc.CAMP_Id AND c.EmpID = oc.EmpID
    INNER JOIN TESISSEG.dbo.AS_FORMCAMP af ON af.CAMP_Id = c.CAMP_Id AND af.EmpID = c.EmpID
    INNER JOIN TESISSEG.dbo.AS_FORMS f ON f.FORM_ID = af.FORM_ID AND f.EmpID = af.EmpID
WHERE f.FORM_Nombre LIKE 'Autos' AND c.CAMP_Nombre LIKE 'uso' AND o.OPC_Valor LIKE 'Empresa'