DELETE FROM [dbo].[ECALRI] WHERE (([CodECalRi] = @Original_CodECalRi) AND ((@IsNull_Descrip = 1 AND [Descrip] IS NULL) OR ([Descrip] = @Original_Descrip))) INSERT INTO [dbo].[ECALRI] ([CodECalRi], [Descrip]) VALUES (@CodECalRi, @Descrip); SELECT CodECalRi, Descrip FROM ECALRI WHERE (CodECalRi = @CodECalRi) SELECT CodECalRi, Descrip FROM dbo.ECALRI UPDATE [dbo].[ECALRI] SET [CodECalRi] = @CodECalRi, [Descrip] = @Descrip WHERE (([CodECalRi] = @Original_CodECalRi) AND ((@IsNull_Descrip = 1 AND [Descrip] IS NULL) OR ([Descrip] = @Original_Descrip))); SELECT CodECalRi, Descrip FROM ECALRI WHERE (CodECalRi = @CodECalRi) DELETE FROM [dbo].[EMIS] WHERE (([CodEmis] = @Original_CodEmis) AND ((@IsNull_Descrip = 1 AND [Descrip] IS NULL) OR ([Descrip] = @Original_Descrip)) AND ((@IsNull_Estado = 1 AND [Estado] IS NULL) OR ([Estado] = @Original_Estado))) INSERT INTO [dbo].[EMIS] ([Descrip], [Estado]) VALUES (@Descrip, @Estado); SELECT CodEmis, Descrip, Estado FROM EMIS WHERE (CodEmis = SCOPE_IDENTITY()) SELECT CodEmis, Descrip, Estado FROM dbo.EMIS UPDATE [dbo].[EMIS] SET [Descrip] = @Descrip, [Estado] = @Estado WHERE (([CodEmis] = @Original_CodEmis) AND ((@IsNull_Descrip = 1 AND [Descrip] IS NULL) OR ([Descrip] = @Original_Descrip)) AND ((@IsNull_Estado = 1 AND [Estado] IS NULL) OR ([Estado] = @Original_Estado))); SELECT CodEmis, Descrip, Estado FROM EMIS WHERE (CodEmis = @CodEmis) DELETE FROM [EMPR] WHERE (([CodEmpr] = @Original_CodEmpr) AND ((@IsNull_Descrip = 1 AND [Descrip] IS NULL) OR ([Descrip] = @Original_Descrip)) AND ((@IsNull_SAP_BD = 1 AND [SAP_BD] IS NULL) OR ([SAP_BD] = @Original_SAP_BD))) INSERT INTO EMPR (CodEmpr, Descrip, SAP_BD) VALUES (@CodEmpr,@Descrip,@SAP_BD); SELECT CodEmpr, Descrip, SAP_BD FROM EMPR WHERE (CodEmpr = @CodEmpr) SELECT CodEmpr, Descrip, SAP_BD FROM EMPR UPDATE EMPR SET Descrip = @Descrip, SAP_BD = @SAP_BD WHERE (CodEmpr = @Original_CodEmpr); SELECT CodEmpr, Descrip, SAP_BD FROM EMPR WHERE (CodEmpr = @CodEmpr) DELETE FROM [dbo].[INFI] WHERE (([CodIF] = @Original_CodIF) AND ((@IsNull_Descrip = 1 AND [Descrip] IS NULL) OR ([Descrip] = @Original_Descrip)) AND ((@IsNull_Tipo = 1 AND [Tipo] IS NULL) OR ([Tipo] = @Original_Tipo))) INSERT INTO [dbo].[INFI] ([CodIF], [Descrip], [Tipo]) VALUES (@CodIF, @Descrip, @Tipo); SELECT CodIF, Descrip, Tipo FROM INFI WHERE (CodIF = @CodIF) SELECT CodIF, Descrip, Tipo FROM dbo.INFI UPDATE [dbo].[INFI] SET [CodIF] = @CodIF, [Descrip] = @Descrip, [Tipo] = @Tipo WHERE (([CodIF] = @Original_CodIF) AND ((@IsNull_Descrip = 1 AND [Descrip] IS NULL) OR ([Descrip] = @Original_Descrip)) AND ((@IsNull_Tipo = 1 AND [Tipo] IS NULL) OR ([Tipo] = @Original_Tipo))); SELECT CodIF, Descrip, Tipo FROM INFI WHERE (CodIF = @CodIF) DELETE FROM [dbo].[PAIS] WHERE (([CodPais] = @Original_CodPais) AND ((@IsNull_Descrip = 1 AND [Descrip] IS NULL) OR ([Descrip] = @Original_Descrip)) AND ((@IsNull_RelInv = 1 AND [RelInv] IS NULL) OR ([RelInv] = @Original_RelInv))) INSERT INTO [dbo].[PAIS] ([CodPais], [Descrip], [RelInv]) VALUES (@CodPais, @Descrip, @RelInv); SELECT CodPais, Descrip, RelInv FROM PAIS WHERE (CodPais = @CodPais) SELECT CodPais, Descrip, RelInv FROM dbo.PAIS UPDATE [dbo].[PAIS] SET [CodPais] = @CodPais, [Descrip] = @Descrip, [RelInv] = @RelInv WHERE (([CodPais] = @Original_CodPais) AND ((@IsNull_Descrip = 1 AND [Descrip] IS NULL) OR ([Descrip] = @Original_Descrip)) AND ((@IsNull_RelInv = 1 AND [RelInv] IS NULL) OR ([RelInv] = @Original_RelInv))); SELECT CodPais, Descrip, RelInv FROM PAIS WHERE (CodPais = @CodPais) dbo.SP_InventarioMaster DELETE FROM BAN0 WHERE (CodBanco = @Original_CodBanco) INSERT INTO BAN0 (CodBanco, CodPais, NombreBanco) VALUES (@CodBanco,@CodPais,@NombreBanco); SELECT CodBanco, CodPais, NombreBanco FROM BAN0 WHERE (CodBanco = @CodBanco) SELECT CodBanco, CodPais, NombreBanco FROM BAN0 UPDATE BAN0 SET CodBanco = @CodBanco, CodPais = @CodPais, NombreBanco = @NombreBanco WHERE (CodBanco = @Original_CodBanco); SELECT CodBanco, CodPais, NombreBanco FROM BAN0 WHERE (CodBanco = @CodBanco) DELETE FROM [BAN1] WHERE (([Id] = @Original_Id) AND ((@IsNull_CodBanco = 1 AND [CodBanco] IS NULL) OR ([CodBanco] = @Original_CodBanco)) AND ((@IsNull_CodEmpr = 1 AND [CodEmpr] IS NULL) OR ([CodEmpr] = @Original_CodEmpr)) AND ((@IsNull_NumCuenta = 1 AND [NumCuenta] IS NULL) OR ([NumCuenta] = @Original_NumCuenta)) AND ((@IsNull_Activo = 1 AND [Activo] IS NULL) OR ([Activo] = @Original_Activo)) AND ((@IsNull_NombreCuenta = 1 AND [NombreCuenta] IS NULL) OR ([NombreCuenta] = @Original_NombreCuenta)) AND ((@IsNull_TipoCuenta = 1 AND [TipoCuenta] IS NULL) OR ([TipoCuenta] = @Original_TipoCuenta)) AND ((@IsNull_CuentaContable = 1 AND [CuentaContable] IS NULL) OR ([CuentaContable] = @Original_CuentaContable))) INSERT INTO [BAN1] ([CodBanco], [CodEmpr], [NumCuenta], [Activo], [NombreCuenta], [TipoCuenta], [CuentaContable]) VALUES (@CodBanco, @CodEmpr, @NumCuenta, @Activo, @NombreCuenta, @TipoCuenta, @CuentaContable); SELECT Id, CodBanco, CodEmpr, NumCuenta, Activo, NombreCuenta, TipoCuenta, CuentaContable FROM BAN1 WHERE (Id = SCOPE_IDENTITY()) SELECT Id, CodBanco, CodEmpr, NumCuenta, Activo, NombreCuenta, TipoCuenta, CuentaContable FROM BAN1 UPDATE BAN1 SET CodBanco = @CodBanco, CodEmpr = @CodEmpr, NumCuenta = @NumCuenta, Activo = @Activo, NombreCuenta = @NombreCuenta, TipoCuenta = @TipoCuenta, CuentaContable = @CuentaContable WHERE (Id = @Original_Id) AND (@IsNull_CodBanco = 1 AND CodBanco IS NULL OR CodBanco = @Original_CodBanco) AND (@IsNull_CodEmpr = 1 AND CodEmpr IS NULL OR CodEmpr = @Original_CodEmpr) AND (@IsNull_NumCuenta = 1 AND NumCuenta IS NULL OR NumCuenta = @Original_NumCuenta) AND (@IsNull_Activo = 1 AND Activo IS NULL OR Activo = @Original_Activo) AND (@IsNull_NombreCuenta = 1 AND NombreCuenta IS NULL OR NombreCuenta = @Original_NombreCuenta) AND (@IsNull_TipoCuenta = 1 AND TipoCuenta IS NULL OR TipoCuenta = @Original_TipoCuenta) AND (@IsNull_CuentaContable = 1 AND CuentaContable IS NULL OR CuentaContable = @Original_CuentaContable); SELECT Id, CodBanco, CodEmpr, NumCuenta, Activo, NombreCuenta, TipoCuenta, CuentaContable FROM BAN1 WHERE (Id = @Id) SELECT Id, CodBanco, CodEmpr, NumCuenta, Activo, NombreCuenta FROM BAN1 DELETE FROM [dbo].[FPAG] WHERE (([Codigo] = @Original_Codigo) AND ((@IsNull_Nombre = 1 AND [Nombre] IS NULL) OR ([Nombre] = @Original_Nombre))) INSERT INTO [dbo].[FPAG] ([Codigo], [Nombre]) VALUES (@Codigo, @Nombre); SELECT Codigo, Nombre FROM FPAG WHERE (Codigo = @Codigo) SELECT Codigo, Nombre FROM dbo.FPAG UPDATE [dbo].[FPAG] SET [Codigo] = @Codigo, [Nombre] = @Nombre WHERE (([Codigo] = @Original_Codigo) AND ((@IsNull_Nombre = 1 AND [Nombre] IS NULL) OR ([Nombre] = @Original_Nombre))); SELECT Codigo, Nombre FROM FPAG WHERE (Codigo = @Codigo) DELETE FROM [dbo].[PIN0] WHERE (([DocId] = @Original_DocId) AND ((@IsNull_CodInv = 1 AND [CodInv] IS NULL) OR ([CodInv] = @Original_CodInv)) AND ((@IsNull_DocEst = 1 AND [DocEst] IS NULL) OR ([DocEst] = @Original_DocEst)) AND ((@IsNull_Asunto = 1 AND [Asunto] IS NULL) OR ([Asunto] = @Original_Asunto)) AND ((@IsNull_CodEmpr = 1 AND [CodEmpr] IS NULL) OR ([CodEmpr] = @Original_CodEmpr)) AND ((@IsNull_CodIF = 1 AND [CodIF] IS NULL) OR ([CodIF] = @Original_CodIF)) AND ((@IsNull_CodEmis = 1 AND [CodEmis] IS NULL) OR ([CodEmis] = @Original_CodEmis)) AND ((@IsNull_CodCalRi = 1 AND [CodCalRi] IS NULL) OR ([CodCalRi] = @Original_CodCalRi)) AND ((@IsNull_CodECalRi = 1 AND [CodECalRi] IS NULL) OR ([CodECalRi] = @Original_CodECalRi)) AND ((@IsNull_OFon = 1 AND [OFon] IS NULL) OR ([OFon] = @Original_OFon)) AND ((@IsNull_Coment = 1 AND [Coment] IS NULL) OR ([Coment] = @Original_Coment)) AND ((@IsNull_Just = 1 AND [Just] IS NULL) OR ([Just] = @Original_Just)) AND ((@IsNull_TipoOper = 1 AND [TipoOper] IS NULL) OR ([TipoOper] = @Original_TipoOper)) AND ((@IsNull_DocBase = 1 AND [DocBase] IS NULL) OR ([DocBase] = @Original_DocBase)) AND ((@IsNull_MontoInv = 1 AND [MontoInv] IS NULL) OR ([MontoInv] = @Original_MontoInv)) AND ((@IsNull_Precio = 1 AND [Precio] IS NULL) OR ([Precio] = @Original_Precio)) AND ((@IsNull_Rendimiento = 1 AND [Rendimiento] IS NULL) OR ([Rendimiento] = @Original_Rendimiento)) AND ((@IsNull_Plazo = 1 AND [Plazo] IS NULL) OR ([Plazo] = @Original_Plazo)) AND ((@IsNull_PlazoFact = 1 AND [PlazoFact] IS NULL) OR ([PlazoFact] = @Original_PlazoFact)) AND ((@IsNull_Ingresos = 1 AND [Ingresos] IS NULL) OR ([Ingresos] = @Original_Ingresos)) AND ((@IsNull_FechaDoc = 1 AND [FechaDoc] IS NULL) OR ([FechaDoc] = @Original_FechaDoc)) AND ((@IsNull_AutEstado = 1 AND [AutEstado] IS NULL) OR ([AutEstado] = @Original_AutEstado)) AND ((@IsNull_TipoMerc = 1 AND [TipoMerc] IS NULL) OR ([TipoMerc] = @Original_TipoMerc)) AND ((@IsNull_CodPais = 1 AND [CodPais] IS NULL) OR ([CodPais] = @Original_CodPais))) INSERT INTO [dbo].[PIN0] ([CodInv], [DocEst], [Asunto], [CodEmpr], [CodIF], [CodEmis], [CodCalRi], [CodECalRi], [OFon], [Coment], [Just], [TipoOper], [DocBase], [MontoInv], [Precio], [Rendimiento], [Plazo], [PlazoFact], [Ingresos], [FechaDoc], [AutEstado], [TipoMerc], [CodPais]) VALUES (@CodInv, @DocEst, @Asunto, @CodEmpr, @CodIF, @CodEmis, @CodCalRi, @CodECalRi, @OFon, @Coment, @Just, @TipoOper, @DocBase, @MontoInv, @Precio, @Rendimiento, @Plazo, @PlazoFact, @Ingresos, @FechaDoc, @AutEstado, @TipoMerc, @CodPais); SELECT DocId, CodInv, DocEst, Asunto, CodEmpr, CodIF, CodEmis, CodCalRi, CodECalRi, OFon, Coment, Just, TipoOper, DocBase, MontoInv, Precio, Rendimiento, Plazo, PlazoFact, Ingresos, FechaDoc, AutEstado, TipoMerc, CodPais FROM PIN0 WHERE (DocId = SCOPE_IDENTITY()) SELECT DocId, CodInv, DocEst, Asunto, CodEmpr, CodIF, CodEmis, CodCalRi, CodECalRi, OFon, Coment, Just, TipoOper, DocBase, MontoInv, Precio, Rendimiento, Plazo, PlazoFact, Ingresos, FechaDoc, AutEstado, TipoMerc, CodPais FROM dbo.PIN0 UPDATE [dbo].[PIN0] SET [CodInv] = @CodInv, [DocEst] = @DocEst, [Asunto] = @Asunto, [CodEmpr] = @CodEmpr, [CodIF] = @CodIF, [CodEmis] = @CodEmis, [CodCalRi] = @CodCalRi, [CodECalRi] = @CodECalRi, [OFon] = @OFon, [Coment] = @Coment, [Just] = @Just, [TipoOper] = @TipoOper, [DocBase] = @DocBase, [MontoInv] = @MontoInv, [Precio] = @Precio, [Rendimiento] = @Rendimiento, [Plazo] = @Plazo, [PlazoFact] = @PlazoFact, [Ingresos] = @Ingresos, [FechaDoc] = @FechaDoc, [AutEstado] = @AutEstado, [TipoMerc] = @TipoMerc, [CodPais] = @CodPais WHERE (([DocId] = @Original_DocId) AND ((@IsNull_CodInv = 1 AND [CodInv] IS NULL) OR ([CodInv] = @Original_CodInv)) AND ((@IsNull_DocEst = 1 AND [DocEst] IS NULL) OR ([DocEst] = @Original_DocEst)) AND ((@IsNull_Asunto = 1 AND [Asunto] IS NULL) OR ([Asunto] = @Original_Asunto)) AND ((@IsNull_CodEmpr = 1 AND [CodEmpr] IS NULL) OR ([CodEmpr] = @Original_CodEmpr)) AND ((@IsNull_CodIF = 1 AND [CodIF] IS NULL) OR ([CodIF] = @Original_CodIF)) AND ((@IsNull_CodEmis = 1 AND [CodEmis] IS NULL) OR ([CodEmis] = @Original_CodEmis)) AND ((@IsNull_CodCalRi = 1 AND [CodCalRi] IS NULL) OR ([CodCalRi] = @Original_CodCalRi)) AND ((@IsNull_CodECalRi = 1 AND [CodECalRi] IS NULL) OR ([CodECalRi] = @Original_CodECalRi)) AND ((@IsNull_OFon = 1 AND [OFon] IS NULL) OR ([OFon] = @Original_OFon)) AND ((@IsNull_Coment = 1 AND [Coment] IS NULL) OR ([Coment] = @Original_Coment)) AND ((@IsNull_Just = 1 AND [Just] IS NULL) OR ([Just] = @Original_Just)) AND ((@IsNull_TipoOper = 1 AND [TipoOper] IS NULL) OR ([TipoOper] = @Original_TipoOper)) AND ((@IsNull_DocBase = 1 AND [DocBase] IS NULL) OR ([DocBase] = @Original_DocBase)) AND ((@IsNull_MontoInv = 1 AND [MontoInv] IS NULL) OR ([MontoInv] = @Original_MontoInv)) AND ((@IsNull_Precio = 1 AND [Precio] IS NULL) OR ([Precio] = @Original_Precio)) AND ((@IsNull_Rendimiento = 1 AND [Rendimiento] IS NULL) OR ([Rendimiento] = @Original_Rendimiento)) AND ((@IsNull_Plazo = 1 AND [Plazo] IS NULL) OR ([Plazo] = @Original_Plazo)) AND ((@IsNull_PlazoFact = 1 AND [PlazoFact] IS NULL) OR ([PlazoFact] = @Original_PlazoFact)) AND ((@IsNull_Ingresos = 1 AND [Ingresos] IS NULL) OR ([Ingresos] = @Original_Ingresos)) AND ((@IsNull_FechaDoc = 1 AND [FechaDoc] IS NULL) OR ([FechaDoc] = @Original_FechaDoc)) AND ((@IsNull_AutEstado = 1 AND [AutEstado] IS NULL) OR ([AutEstado] = @Original_AutEstado)) AND ((@IsNull_TipoMerc = 1 AND [TipoMerc] IS NULL) OR ([TipoMerc] = @Original_TipoMerc)) AND ((@IsNull_CodPais = 1 AND [CodPais] IS NULL) OR ([CodPais] = @Original_CodPais))); SELECT DocId, CodInv, DocEst, Asunto, CodEmpr, CodIF, CodEmis, CodCalRi, CodECalRi, OFon, Coment, Just, TipoOper, DocBase, MontoInv, Precio, Rendimiento, Plazo, PlazoFact, Ingresos, FechaDoc, AutEstado, TipoMerc, CodPais FROM PIN0 WHERE (DocId = @DocId) DELETE FROM [dbo].[CALRI] WHERE (([CodCalRi] = @Original_CodCalRi) AND ((@IsNull_Descrip = 1 AND [Descrip] IS NULL) OR ([Descrip] = @Original_Descrip))) INSERT INTO [dbo].[CALRI] ([CodCalRi], [Descrip]) VALUES (@CodCalRi, @Descrip); SELECT CodCalRi, Descrip FROM CALRI WHERE (CodCalRi = @CodCalRi) SELECT CodCalRi, Descrip FROM dbo.CALRI UPDATE [dbo].[CALRI] SET [CodCalRi] = @CodCalRi, [Descrip] = @Descrip WHERE (([CodCalRi] = @Original_CodCalRi) AND ((@IsNull_Descrip = 1 AND [Descrip] IS NULL) OR ([Descrip] = @Original_Descrip))); SELECT CodCalRi, Descrip FROM CALRI WHERE (CodCalRi = @CodCalRi) DELETE FROM [RPAG] WHERE (([RPID] = @Original_RPID) AND ((@IsNull_CodInv = 1 AND [CodInv] IS NULL) OR ([CodInv] = @Original_CodInv)) AND ((@IsNull_AFavorDe = 1 AND [AFavorDe] IS NULL) OR ([AFavorDe] = @Original_AFavorDe)) AND ((@IsNull_FormaPagID = 1 AND [FormaPagID] IS NULL) OR ([FormaPagID] = @Original_FormaPagID)) AND ((@IsNull_MontoPago = 1 AND [MontoPago] IS NULL) OR ([MontoPago] = @Original_MontoPago)) AND ((@IsNull_FechaPago = 1 AND [FechaPago] IS NULL) OR ([FechaPago] = @Original_FechaPago)) AND ((@IsNull_CodBanco = 1 AND [CodBanco] IS NULL) OR ([CodBanco] = @Original_CodBanco)) AND ((@IsNull_NumCuenta = 1 AND [NumCuenta] IS NULL) OR ([NumCuenta] = @Original_NumCuenta)) AND ((@IsNull_SaldoContable = 1 AND [SaldoContable] IS NULL) OR ([SaldoContable] = @Original_SaldoContable)) AND ((@IsNull_Concepto = 1 AND [Concepto] IS NULL) OR ([Concepto] = @Original_Concepto)) AND ((@IsNull_UCodigo = 1 AND [UCodigo] IS NULL) OR ([UCodigo] = @Original_UCodigo))) INSERT INTO RPAG (CodInv, AFavorDe, FormaPagID, MontoPago, FechaPago, CodBanco, NumCuenta, SaldoContable, Concepto, UCodigo) VALUES (@CodInv,@AFavorDe,@FormaPagID,@MontoPago,@FechaPago,@CodBanco,@NumCuenta,@SaldoContable,@Concepto,@UCodigo); SELECT RPID, CodInv, AFavorDe, FormaPagID, MontoPago, FechaPago, CodBanco, NumCuenta, SaldoContable, Concepto, UCodigo FROM RPAG WHERE (RPID = SCOPE_IDENTITY()) SELECT RPID, CodInv, AFavorDe, FormaPagID, MontoPago, FechaPago, CodBanco, NumCuenta, SaldoContable, Concepto, UCodigo FROM RPAG UPDATE [RPAG] SET [CodInv] = @CodInv, [AFavorDe] = @AFavorDe, [FormaPagID] = @FormaPagID, [MontoPago] = @MontoPago, [FechaPago] = @FechaPago, [CodBanco] = @CodBanco, [NumCuenta] = @NumCuenta, [SaldoContable] = @SaldoContable, [Concepto] = @Concepto, [UCodigo] = @UCodigo WHERE (([RPID] = @Original_RPID) AND ((@IsNull_CodInv = 1 AND [CodInv] IS NULL) OR ([CodInv] = @Original_CodInv)) AND ((@IsNull_AFavorDe = 1 AND [AFavorDe] IS NULL) OR ([AFavorDe] = @Original_AFavorDe)) AND ((@IsNull_FormaPagID = 1 AND [FormaPagID] IS NULL) OR ([FormaPagID] = @Original_FormaPagID)) AND ((@IsNull_MontoPago = 1 AND [MontoPago] IS NULL) OR ([MontoPago] = @Original_MontoPago)) AND ((@IsNull_FechaPago = 1 AND [FechaPago] IS NULL) OR ([FechaPago] = @Original_FechaPago)) AND ((@IsNull_CodBanco = 1 AND [CodBanco] IS NULL) OR ([CodBanco] = @Original_CodBanco)) AND ((@IsNull_NumCuenta = 1 AND [NumCuenta] IS NULL) OR ([NumCuenta] = @Original_NumCuenta)) AND ((@IsNull_SaldoContable = 1 AND [SaldoContable] IS NULL) OR ([SaldoContable] = @Original_SaldoContable)) AND ((@IsNull_Concepto = 1 AND [Concepto] IS NULL) OR ([Concepto] = @Original_Concepto)) AND ((@IsNull_UCodigo = 1 AND [UCodigo] IS NULL) OR ([UCodigo] = @Original_UCodigo))); SELECT RPID, CodInv, AFavorDe, FormaPagID, MontoPago, FechaPago, CodBanco, NumCuenta, SaldoContable, Concepto, UCodigo FROM RPAG WHERE (RPID = @RPID) DELETE FROM [dbo].[BAN2] WHERE (([Codigo] = @Original_Codigo) AND ((@IsNull_Nombre = 1 AND [Nombre] IS NULL) OR ([Nombre] = @Original_Nombre))) INSERT INTO [dbo].[BAN2] ([Codigo], [Nombre]) VALUES (@Codigo, @Nombre); SELECT Codigo, Nombre FROM BAN2 WHERE (Codigo = @Codigo) SELECT Codigo, Nombre FROM dbo.BAN2 UPDATE [dbo].[BAN2] SET [Codigo] = @Codigo, [Nombre] = @Nombre WHERE (([Codigo] = @Original_Codigo) AND ((@IsNull_Nombre = 1 AND [Nombre] IS NULL) OR ([Nombre] = @Original_Nombre))); SELECT Codigo, Nombre FROM BAN2 WHERE (Codigo = @Codigo) DELETE FROM [dbo].[OFON] WHERE (([Codigo] = @Original_Codigo) AND ((@IsNull_Descrip = 1 AND [Descrip] IS NULL) OR ([Descrip] = @Original_Descrip))) INSERT INTO [dbo].[OFON] ([Codigo], [Descrip]) VALUES (@Codigo, @Descrip); SELECT Codigo, Descrip FROM OFON WHERE (Codigo = @Codigo) SELECT Codigo, Descrip FROM dbo.OFON UPDATE [dbo].[OFON] SET [Codigo] = @Codigo, [Descrip] = @Descrip WHERE (([Codigo] = @Original_Codigo) AND ((@IsNull_Descrip = 1 AND [Descrip] IS NULL) OR ([Descrip] = @Original_Descrip))); SELECT Codigo, Descrip FROM OFON WHERE (Codigo = @Codigo) DELETE FROM DEP0 WHERE (DEPID = @Original_DEPID) INSERT INTO DEP0 (DEPID, DEPNombre) VALUES (@DEPID,@DEPNombre); SELECT DEPID, DEPNombre FROM DEP0 WHERE (DEPID = @DEPID) SELECT DEPID, DEPNombre FROM DEP0 UPDATE DEP0 SET DEPNombre = @DEPNombre WHERE (DEPID = @Original_DEPID); SELECT DEPID, DEPNombre FROM DEP0 WHERE (DEPID = @DEPID) DELETE FROM [USR0] WHERE (([UCodigo] = @Original_UCodigo) AND ((@IsNull_UNombre = 1 AND [UNombre] IS NULL) OR ([UNombre] = @Original_UNombre)) AND ((@IsNull_DEPID = 1 AND [DEPID] IS NULL) OR ([DEPID] = @Original_DEPID)) AND ((@IsNull_SUser = 1 AND [SUser] IS NULL) OR ([SUser] = @Original_SUser)) AND ((@IsNull_Bloqueado = 1 AND [Bloqueado] IS NULL) OR ([Bloqueado] = @Original_Bloqueado)) AND ((@IsNull_Clave1 = 1 AND [Clave1] IS NULL) OR ([Clave1] = @Original_Clave1))) INSERT INTO USR0 (UCodigo, UNombre, DEPID, SUser, Bloqueado, Clave1) VALUES (@UCodigo,@UNombre,@DEPID,@SUser,@Bloqueado,@Clave1); SELECT UCodigo, UNombre, DEPID, SUser, Bloqueado, Clave1 FROM USR0 WHERE (UCodigo = @UCodigo) SELECT UCodigo, UNombre, DEPID, SUser, Bloqueado, Clave1 FROM USR0 UPDATE USR0 SET UNombre = @UNombre, DEPID = @DEPID, SUser = @SUser, Bloqueado = @Bloqueado, Clave1 = @Clave1 WHERE (UCodigo = @Original_UCodigo); SELECT UCodigo, UNombre, DEPID, SUser, Bloqueado, Clave1 FROM USR0 WHERE (UCodigo = @UCodigo)