SELECT value, label FROM v_selClient ORDER BY label dbo.stp_VSCli_SearchLike SELECT value, label FROM dbo.v_selItems dbo.stp_VSItem_SearchLike SELECT value, label FROM dbo.v_selRawMat dbo.stp_VSRM_SearchLike SELECT value, label FROM dbo.v_selCons SELECT value, label FROM dbo.v_selIncoterms DELETE FROM [dbo].[ReportPrintTicket] WHERE (([Ticket] = @Original_Ticket) AND ([Report] = @Original_Report) AND ([Chiave] = @Original_Chiave) AND ([UserReq] = @Original_UserReq) AND ([DataReq] = @Original_DataReq) AND ((@IsNull_DataPrint = 1 AND [DataPrint] IS NULL) OR ([DataPrint] = @Original_DataPrint))) INSERT INTO [dbo].[ReportPrintTicket] ([Ticket], [Report], [Chiave], [UserReq], [DataReq], [DataPrint]) VALUES (@Ticket, @Report, @Chiave, @UserReq, @DataReq, @DataPrint); SELECT Ticket, Report, Chiave, UserReq, DataReq, DataPrint FROM ReportPrintTicket WHERE (Chiave = @Chiave) AND (Report = @Report) AND (Ticket = @Ticket) SELECT Ticket, Report, Chiave, UserReq, DataReq, DataPrint FROM dbo.ReportPrintTicket UPDATE [dbo].[ReportPrintTicket] SET [Ticket] = @Ticket, [Report] = @Report, [Chiave] = @Chiave, [UserReq] = @UserReq, [DataReq] = @DataReq, [DataPrint] = @DataPrint WHERE (([Ticket] = @Original_Ticket) AND ([Report] = @Original_Report) AND ([Chiave] = @Original_Chiave) AND ([UserReq] = @Original_UserReq) AND ([DataReq] = @Original_DataReq) AND ((@IsNull_DataPrint = 1 AND [DataPrint] IS NULL) OR ([DataPrint] = @Original_DataPrint))); SELECT Ticket, Report, Chiave, UserReq, DataReq, DataPrint FROM ReportPrintTicket WHERE (Chiave = @Chiave) AND (Report = @Report) AND (Ticket = @Ticket) dbo.stp_RPT_insertNew dbo.stp_RPT_reserveTicket dbo.stp_checkOffers4Item SELECT value, label FROM dbo.v_selPackage SELECT value, label FROM dbo.v_selPlant dbo.stp_PL_getByListLingua SELECT FromDate, ToDate, NumOrderRows, NumOrders, NumItem, NumClients FROM dbo.v_MarginReportStats tmp.importOrdersHistRaw tmp.stp_convertOrdersHistRaw dbo.stp_OH_countRemaining dbo.stp_QLR_insNew tmp.stp_importOrdersHistRaw ext.stp_mergeOrdersHist SELECT FromDate, ToDate, NumOrderRows, NumOrders, NumItem, NumClients FROM dbo.v_MarginReportStatsNewData SELECT label, value FROM dbo.v_selDateStdCost dbo.stp_SC2C_countRemaining dbo.stp_SC2C_countRemaining dbo.stp_QLC_insNew dbo.stp_SC2C_insertForDate DELETE FROM [dbo].[ListValues] WHERE (([TableName] = @Original_TableName) AND ([FieldName] = @Original_FieldName) AND ([value] = @Original_value) AND ((@IsNull_label = 1 AND [label] IS NULL) OR ([label] = @Original_label)) AND ((@IsNull_ordinal = 1 AND [ordinal] IS NULL) OR ([ordinal] = @Original_ordinal))) INSERT INTO [dbo].[ListValues] ([TableName], [FieldName], [value], [label], [ordinal]) VALUES (@TableName, @FieldName, @value, @label, @ordinal); SELECT TableName, FieldName, value, label, ordinal FROM ListValues WHERE (FieldName = @FieldName) AND (TableName = @TableName) AND (value = @value) SELECT TableName, FieldName, value, label, ordinal FROM dbo.ListValues UPDATE [dbo].[ListValues] SET [TableName] = @TableName, [FieldName] = @FieldName, [value] = @value, [label] = @label, [ordinal] = @ordinal WHERE (([TableName] = @Original_TableName) AND ([FieldName] = @Original_FieldName) AND ([value] = @Original_value) AND ((@IsNull_label = 1 AND [label] IS NULL) OR ([label] = @Original_label)) AND ((@IsNull_ordinal = 1 AND [ordinal] IS NULL) OR ([ordinal] = @Original_ordinal))); SELECT TableName, FieldName, value, label, ordinal FROM ListValues WHERE (FieldName = @FieldName) AND (TableName = @TableName) AND (value = @value) dbo.stp_listValues_delete dbo.stp_listValues_getByTable dbo.stp_listValues_getDistTable dbo.stp_listValues_insNew dbo.stp_listValues_update SELECT value, label FROM dbo.v_selListVal dbo.stp_listValues_getValidValues dbo.stp_listValues_getValidValuesTrad SELECT NumTicket, StpName, StpParam, DataRich, DataStart, DataEnd, Note, IsDone, IsOk FROM Import_TicketList ORDER BY DataRich DESC dbo.stp_ImTL_getPending dbo.stp_ImTL_InsertQuery ext.stp_ticketQueueProcess SELECT * FROM dbo.Import_Log dbo.stp_ImLog_getByTicket SELECT value, label FROM dbo.v_selAgents DELETE FROM [DiesGroupDet] WHERE (([CodDiesGroup] = @Original_CodDiesGroup) AND ([Price] = @Original_Price) AND ([QtyTot] = @Original_QtyTot) AND ([QtyEOL] = @Original_QtyEOL) AND ([ExpLife] = @Original_ExpLife) AND ([EOLLife] = @Original_EOLLife)) INSERT INTO [DiesGroupDet] ([CodDiesGroup], [Price], [QtyTot], [QtyEOL], [ExpLife], [EOLLife]) VALUES (@CodDiesGroup, @Price, @QtyTot, @QtyEOL, @ExpLife, @EOLLife); SELECT CodDiesGroup, Price, QtyTot, QtyEOL, ExpLife, EOLLife FROM DiesGroupDet WHERE (CodDiesGroup = @CodDiesGroup) SELECT CodDiesGroup, Price, QtyTot, QtyEOL, ExpLife, EOLLife FROM DiesGroupDet UPDATE [DiesGroupDet] SET [CodDiesGroup] = @CodDiesGroup, [Price] = @Price, [QtyTot] = @QtyTot, [QtyEOL] = @QtyEOL, [ExpLife] = @ExpLife, [EOLLife] = @EOLLife WHERE (([CodDiesGroup] = @Original_CodDiesGroup) AND ([Price] = @Original_Price) AND ([QtyTot] = @Original_QtyTot) AND ([QtyEOL] = @Original_QtyEOL) AND ([ExpLife] = @Original_ExpLife) AND ([EOLLife] = @Original_EOLLife)); SELECT CodDiesGroup, Price, QtyTot, QtyEOL, ExpLife, EOLLife FROM DiesGroupDet WHERE (CodDiesGroup = @CodDiesGroup) tmp.stp_convertDiesGroupRaw tmp.stp_importDiesGroupRaw ext.stp_mergeDiesGroupDet DELETE FROM [dbo].[TranspCostDet] WHERE (([TranspZone] = @Original_TranspZone) AND ([TranspCost] = @Original_TranspCost)) INSERT INTO [dbo].[TranspCostDet] ([TranspZone], [TranspCost]) VALUES (@TranspZone, @TranspCost); SELECT TranspZone, TranspCost FROM TranspCostDet WHERE (TranspZone = @TranspZone) SELECT TranspZone, TranspCost FROM dbo.TranspCostDet UPDATE [dbo].[TranspCostDet] SET [TranspZone] = @TranspZone, [TranspCost] = @TranspCost WHERE (([TranspZone] = @Original_TranspZone) AND ([TranspCost] = @Original_TranspCost)); SELECT TranspZone, TranspCost FROM TranspCostDet WHERE (TranspZone = @TranspZone) tmp.stp_convertTranspCostRaw tmp.stp_importTranspCostRaw ext.stp_mergeTranspCostDet