SELECT * FROM v_ElencoLotti dbo.stp_EL_getAncestor dbo.stp_EL_getBuiltByHashList dbo.stp_EL_getByHashList dbo.stp_EL_getByKey dbo.stp_EL_getByODL dbo.stp_EL_getBySearch dbo.stp_EL_InsertQuery dbo.stp_EL_UpdateQty SELECT * FROM v_ElencoUdc dbo.stp_EU_getByAL dbo.stp_EU_getByKey dbo.stp_EU_getByLotto dbo.stp_EU_getByIdxOdl dbo.stp_EU_getByPackList dbo.stp_EU_InsertQuery SELECT * FROM dbo.v_AnagArt dbo.stp_AA_getDiBaByHashList dbo.stp_AA_getByKey SELECT * FROM dbo.v_ODL dbo.stp_ODL_getLastByIdxMacc dbo.stp_ODL_getOpenByPost SELECT * FROM dbo.ElencoPost2Queue dbo.stp_EP2Q_getByKey SELECT * FROM v_ElencoAL dbo.stp_EAL_deleteQuery dbo.stp_EAL_getByKey dbo.stp_EAL_getByPackList dbo.stp_EAL_getBySearch dbo.stp_EAL_getByUDC dbo.stp_EAL_insertQuery dbo.stp_EAL_updatePList dbo.stp_EAL_updateQuery dbo.stp_EAL_updateStatus SELECT * FROM v_AnagClienti dbo.stp_ACF_deleteQuery dbo.stp_ACF_getBySearch dbo.stp_ACF_insertQuery dbo.stp_ACF_updateQuery DELETE FROM [dbo].[ElencoAL2UDC] WHERE (([AL] = @Original_AL) AND ([UDC] = @Original_UDC) AND ([OrderListID] = @Original_OrderListID)) INSERT INTO [dbo].[ElencoAL2UDC] ([AL], [UDC], [OrderListID]) VALUES (@AL, @UDC, @OrderListID); SELECT AL, UDC, OrderListID FROM ElencoAL2UDC WHERE (AL = @AL) AND (UDC = @UDC) SELECT * FROM dbo.ElencoAL2UDC UPDATE [dbo].[ElencoAL2UDC] SET [AL] = @AL, [UDC] = @UDC, [OrderListID] = @OrderListID WHERE (([AL] = @Original_AL) AND ([UDC] = @Original_UDC) AND ([OrderListID] = @Original_OrderListID)); SELECT AL, UDC, OrderListID FROM ElencoAL2UDC WHERE (AL = @AL) AND (UDC = @UDC) dbo.stp_EA2U_resetAL dbo.stp_EA2U_upsertQuery SELECT * FROM AnagArticoli2Clienti dbo.stp_AA2C_getByKey SELECT * FROM dbo.v_Macchine DELETE FROM [AnagDestinClienti] WHERE (([CodCliente] = @Original_CodCliente) AND ([CodDestinazione] = @Original_CodDestinazione) AND ([DescDestinazione] = @Original_DescDestinazione) AND ((@IsNull_Indirizzo = 1 AND [Indirizzo] IS NULL) OR ([Indirizzo] = @Original_Indirizzo)) AND ((@IsNull_Cap = 1 AND [Cap] IS NULL) OR ([Cap] = @Original_Cap)) AND ((@IsNull_Localita = 1 AND [Localita] IS NULL) OR ([Localita] = @Original_Localita)) AND ((@IsNull_Provincia = 1 AND [Provincia] IS NULL) OR ([Provincia] = @Original_Provincia)) AND ((@IsNull_Nazione = 1 AND [Nazione] IS NULL) OR ([Nazione] = @Original_Nazione))) INSERT INTO [dbo].[AnagClienti] ([CodCliente], [RagSociale], [Indirizzo], [Localita], [Cap], [Provincia], [Nazione], [IsCli], [IsFor]) VALUES (@CodCliente, @RagSociale, @Indirizzo, @Localita, @Cap, @Provincia, @Nazione, @IsCli, @IsFor); SELECT CodCliente, RagSociale, Indirizzo, Localita, Cap, Provincia, Nazione, IsCli, IsFor FROM AnagClienti WHERE (CodCliente = @CodCliente) SELECT * FROM AnagDestinClienti UPDATE [AnagDestinClienti] SET [CodCliente] = @CodCliente, [CodDestinazione] = @CodDestinazione, [DescDestinazione] = @DescDestinazione, [Indirizzo] = @Indirizzo, [Cap] = @Cap, [Localita] = @Localita, [Provincia] = @Provincia, [Nazione] = @Nazione WHERE (([CodCliente] = @Original_CodCliente) AND ([CodDestinazione] = @Original_CodDestinazione) AND ([DescDestinazione] = @Original_DescDestinazione) AND ((@IsNull_Indirizzo = 1 AND [Indirizzo] IS NULL) OR ([Indirizzo] = @Original_Indirizzo)) AND ((@IsNull_Cap = 1 AND [Cap] IS NULL) OR ([Cap] = @Original_Cap)) AND ((@IsNull_Localita = 1 AND [Localita] IS NULL) OR ([Localita] = @Original_Localita)) AND ((@IsNull_Provincia = 1 AND [Provincia] IS NULL) OR ([Provincia] = @Original_Provincia)) AND ((@IsNull_Nazione = 1 AND [Nazione] IS NULL) OR ([Nazione] = @Original_Nazione))); SELECT CodCliente, CodDestinazione, DescDestinazione, Indirizzo, Cap, Localita, Provincia, Nazione FROM AnagDestinClienti WHERE (CodCliente = @CodCliente) AND (CodDestinazione = @CodDestinazione) dbo.stp_ADC_deleteQuery dbo.stp_ADC_getByCodCli dbo.stp_ADC_insertQuery dbo.stp_ADC_updateQuery SELECT * FROM RegGiacenze dbo.stp_RG_DeleteByOdl dbo.stp_RG_InsertQuery