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 [dbo].[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 [dbo].[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 dbo.EMPR UPDATE [dbo].[EMPR] SET [CodEmpr] = @CodEmpr, [Descrip] = @Descrip, [SAP_BD] = @SAP_BD 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))); 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