SELECT value, label FROM dbo.v_selImpianti order by label SELECT label, value FROM v_selImpianti WHERE (value > 1) ORDER BY label SELECT * FROM dbo.v_selMacchine dbo.stp_VSM_avail4Tag dbo.stp_VSM_getByConditio dbo.stp_VSM_getFull SELECT value, label FROM dbo.v_selPrior SELECT value, label FROM v_selAmbiti ORDER BY label SELECT value, label, conditio FROM dbo.v_selCausaliMacchine dbo.stp_vscm_getByConditio dbo.stp_vscm_getByConditioAndCurr SELECT value, label FROM dbo.v_selTipoGuasto SELECT value, label FROM dbo.v_selSemafori SELECT value, label FROM dbo.v_selFreq SELECT value, label FROM dbo.v_selStato SELECT * FROM dbo.v_selPeriodiTrad dbo.stp_vsp_getByConditio SELECT codImpianto, nomeImpianto, tipoImpianto, codMacchina, nomeMacchina, modello, matricola, anno, kgPeso, kwConsumo FROM dbo.v_elencoImpiantiMacchine SELECT numIntMtz, richiesta, codImpianto, nomeImpianto, codMacchina, nomeMacchina, descrizione, inizioIntervento, fineIntervento, descrizioneIntervento, descrCausale, guasto, idxStato, idxImpianto, idxMacchina, isFermo, scheduled FROM v_elencoIntervFilt dbo.stp_elencoIntByIntervDate dbo.stp_elencoIntByIntervDateUserFilt dbo.stp_elencoIntByIntervDateUserFilt_fermaPrev dbo.sp_elencoIntMTBF_MTTR dbo.stp_elencoIntMTBF_MTTR_fermaPrev SELECT value, label FROM dbo.v_selFam SELECT * FROM v_selOperMtz SELECT * FROM v_selOperMtz WHERE (value = @value) SELECT idxPending, codImpianto, nomeImpianto, codMacchina, nomeMacchina, data, descrizione, descrPriorita, isFermo, descrTipo, idxTipo, idxMacchina, idxImpianto FROM v_mtzProgPendingExp dbo.stp_MPP_getByMaxData dbo.stp_MPP_getBySearch SELECT value, label FROM dbo.v_selAnTipoRis SELECT value, label FROM dbo.v_selListVal dbo.stp_listValues_getValidValues dbo.stp_listValues_getValidValuesTrad DELETE FROM [dbo].[ListValues] WHERE (([TableName] = @Original_TableName) AND ([FieldName] = @Original_FieldName) AND ([value] = @Original_value)) INSERT INTO [dbo].[ListValues] ([TableName], [FieldName], [value], [label], [ordinal]) VALUES (@TableName, @FieldName, @value, @label, @ordinal) 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)) dbo.stp_listValues_getByTable dbo.stp_listValues_getDistTable SELECT * FROM dbo.v_selCodRicAmm dbo.stp_scra_getByConditio dbo.stp_scra_getByKey SELECT value, label FROM dbo.v_selGrpCodRicAmm ORDER BY label