DELETE FROM [dbo].[INV0] WHERE (([DocId] = @Original_DocId) AND ([CodInv] = @Original_CodInv) AND ([DocEst] = @Original_DocEst) AND ((@IsNull_AutEstado = 1 AND [AutEstado] IS NULL) OR ([AutEstado] = @Original_AutEstado)) AND ((@IsNull_Asunto = 1 AND [Asunto] IS NULL) OR ([Asunto] = @Original_Asunto)) AND ([CodEmpr] = @Original_CodEmpr) AND ([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 ([FechaDoc] = @Original_FechaDoc) AND ((@IsNull_TipoMerc = 1 AND [TipoMerc] IS NULL) OR ([TipoMerc] = @Original_TipoMerc)) AND ((@IsNull_CodPais = 1 AND [CodPais] IS NULL) OR ([CodPais] = @Original_CodPais)) AND ((@IsNull_NombreManIF = 1 AND [NombreManIF] IS NULL) OR ([NombreManIF] = @Original_NombreManIF)) AND ((@IsNull_CodManIF = 1 AND [CodManIF] IS NULL) OR ([CodManIF] = @Original_CodManIF)) AND ((@IsNull_Periodicidad = 1 AND [Periodicidad] IS NULL) OR ([Periodicidad] = @Original_Periodicidad)) AND ((@IsNull_TipTasa = 1 AND [TipTasa] IS NULL) OR ([TipTasa] = @Original_TipTasa)) AND ((@IsNull_TipRenta = 1 AND [TipRenta] IS NULL) OR ([TipRenta] = @Original_TipRenta)) AND ((@IsNull_NumManInv = 1 AND [NumManInv] IS NULL) OR ([NumManInv] = @Original_NumManInv))) INSERT INTO [dbo].[INV0] ([CodInv], [DocEst], [AutEstado], [Asunto], [CodEmpr], [CodIF], [CodEmis], [CodCalRi], [CodECalRi], [OFon], [Coment], [Just], [TipoOper], [DocBase], [MontoInv], [Precio], [Rendimiento], [Plazo], [PlazoFact], [Ingresos], [FechaDoc], [TipoMerc], [CodPais], [NombreManIF], [CodManIF], [Periodicidad], [TipTasa], [TipRenta], [NumManInv]) VALUES (@CodInv, @DocEst, @AutEstado, @Asunto, @CodEmpr, @CodIF, @CodEmis, @CodCalRi, @CodECalRi, @OFon, @Coment, @Just, @TipoOper, @DocBase, @MontoInv, @Precio, @Rendimiento, @Plazo, @PlazoFact, @Ingresos, @FechaDoc, @TipoMerc, @CodPais, @NombreManIF, @CodManIF, @Periodicidad, @TipTasa, @TipRenta, @NumManInv); SELECT DocId, CodInv, DocEst, AutEstado, Asunto, CodEmpr, CodIF, CodEmis, CodCalRi, CodECalRi, OFon, Coment, Just, TipoOper, DocBase, MontoInv, Precio, Rendimiento, Plazo, PlazoFact, Ingresos, FechaDoc, TipoMerc, CodPais, NombreManIF, CodManIF, Periodicidad, TipTasa, TipRenta, NumManInv FROM INV0 WHERE (CodInv = @CodInv) AND (DocId = SCOPE_IDENTITY()) SELECT DocId, CodInv, DocEst, AutEstado, Asunto, CodEmpr, CodIF, CodEmis, CodCalRi, CodECalRi, OFon, Coment, Just, TipoOper, DocBase, MontoInv, Precio, Rendimiento, Plazo, PlazoFact, Ingresos, FechaDoc, TipoMerc, CodPais, NombreManIF, CodManIF, Periodicidad, TipTasa, TipRenta, NumManInv FROM dbo.INV0 UPDATE [dbo].[INV0] SET [CodInv] = @CodInv, [DocEst] = @DocEst, [AutEstado] = @AutEstado, [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, [TipoMerc] = @TipoMerc, [CodPais] = @CodPais, [NombreManIF] = @NombreManIF, [CodManIF] = @CodManIF, [Periodicidad] = @Periodicidad, [TipTasa] = @TipTasa, [TipRenta] = @TipRenta, [NumManInv] = @NumManInv WHERE (([DocId] = @Original_DocId) AND ([CodInv] = @Original_CodInv) AND ([DocEst] = @Original_DocEst) AND ((@IsNull_AutEstado = 1 AND [AutEstado] IS NULL) OR ([AutEstado] = @Original_AutEstado)) AND ((@IsNull_Asunto = 1 AND [Asunto] IS NULL) OR ([Asunto] = @Original_Asunto)) AND ([CodEmpr] = @Original_CodEmpr) AND ([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 ([FechaDoc] = @Original_FechaDoc) AND ((@IsNull_TipoMerc = 1 AND [TipoMerc] IS NULL) OR ([TipoMerc] = @Original_TipoMerc)) AND ((@IsNull_CodPais = 1 AND [CodPais] IS NULL) OR ([CodPais] = @Original_CodPais)) AND ((@IsNull_NombreManIF = 1 AND [NombreManIF] IS NULL) OR ([NombreManIF] = @Original_NombreManIF)) AND ((@IsNull_CodManIF = 1 AND [CodManIF] IS NULL) OR ([CodManIF] = @Original_CodManIF)) AND ((@IsNull_Periodicidad = 1 AND [Periodicidad] IS NULL) OR ([Periodicidad] = @Original_Periodicidad)) AND ((@IsNull_TipTasa = 1 AND [TipTasa] IS NULL) OR ([TipTasa] = @Original_TipTasa)) AND ((@IsNull_TipRenta = 1 AND [TipRenta] IS NULL) OR ([TipRenta] = @Original_TipRenta)) AND ((@IsNull_NumManInv = 1 AND [NumManInv] IS NULL) OR ([NumManInv] = @Original_NumManInv))); SELECT DocId, CodInv, DocEst, AutEstado, Asunto, CodEmpr, CodIF, CodEmis, CodCalRi, CodECalRi, OFon, Coment, Just, TipoOper, DocBase, MontoInv, Precio, Rendimiento, Plazo, PlazoFact, Ingresos, FechaDoc, TipoMerc, CodPais, NombreManIF, CodManIF, Periodicidad, TipTasa, TipRenta, NumManInv FROM INV0 WHERE (CodInv = @CodInv) AND (DocId = @DocId)