Samuele E. Locatelli
18 lines
375 B
SQL
18 lines
375 B
SQL
-- =============================================
|
|
-- Author: S.E.Locatelli
|
|
-- Create date: 2013.12.27
|
|
-- Description: ricerca causali by conditio
|
|
-- =============================================
|
|
create PROCEDURE stp_vscm_getByConditio
|
|
(
|
|
@conditio INT = 0
|
|
)
|
|
AS
|
|
|
|
SELECT value, label, conditio
|
|
FROM v_selCausaliMacchine
|
|
WHERE (conditio = @conditio)
|
|
|
|
|
|
RETURN
|