-- Cambiar la X por el id de correduría de Advans en PRO
UPDATE A SET A.INC_PublicableColaborador = 0
FROM TESISSEG.dbo.AS_INCIDENCIAS A
WHERE A.EmpID = X AND A.INC_TipoObj IN (7,13) AND A.INC_PublicableColaborador = 1

UPDATE A SET A.DocWVisP = 'S'
FROM TSSGESDOC.dbo.GesDoc A 
WHERE A.EmpID = X AND A.ApaID IN ('SINIESTROS','POLIZAS') AND A.DocWVisP = 'N' AND A.DocName LIKE '%pdf%'

UPDATE A SET A.DocWVisP = 'N'
FROM TSSGESDOC.dbo.GesDoc A 
WHERE A.EmpID = X AND A.ApaID IN ('SINIESTROS','POLIZAS') AND A.DocWVisP = 'S' AND A.DocName NOT LIKE '%pdf%'