Advertisement
brunobola

Untitled

Feb 9th, 2023
112
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 1.07 KB | None | 0 0
  1.                 BSO.DSO.ExecuteSQL("UPDATE TMP_Empresas set Logotipo = (select TOP 1 Logotipo from PRIEMPRE..Empresas Where Codigo='" + BSO.Contexto.CodEmp + "')");
  2.                 BSO.DSO.ExecuteSQL("UPDATE CabLiq set CDU_Logotipo = (select TOP 1 Logotipo from TMP_Empresas) from CabLiq where CDU_Logotipo is null Or ISNULL(CDU_Logotipo,'')<>''");
  3.                 BSO.DSO.ExecuteSQL("UPDATE CabecDoc set CDU_Logotipo = (select TOP 1 Logotipo from TMP_Empresas) from CabecDoc where CDU_Logotipo is null Or ISNULL(CDU_Logotipo,'')<>''");
  4.                 BSO.DSO.ExecuteSQL("UPDATE cabeccompras set CDU_Logotipo = (select TOP 1 Logotipo from TMP_Empresas) from cabeccompras where CDU_Logotipo is null Or ISNULL(CDU_Logotipo,'')<>''");
  5.                 BSO.DSO.ExecuteSQL("DISABLE TRIGGER ALL ON dbo.CabecInternos");
  6.                 BSO.DSO.ExecuteSQL("UPDATE CabecInternos set CDU_Logotipo = (select TOP 1 Logotipo from TMP_Empresas) from CabecInternos where CDU_Logotipo is null Or ISNULL(CDU_Logotipo,'')<>''");
  7.                 BSO.DSO.ExecuteSQL("ENABLE TRIGGER ALL ON dbo.CabecInternos");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement