1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40
| CREATE PROCEDURE [dbo].[spSGM_InsDefautTest]
(
@pt_num varchar(18),
@ni_num varchar(23),
@dt_designation varchar(40),
@mt_test varchar(25)
)
AS
DECLARE @mt_passage smallint
IF EXISTS (SELECT mt_passage = @mt_passage FROM mvtTest WHERE ni_num = @ni_num AND pt_num=@pt_num AND mt_test=@mt_test AND mt_statut='NOGO')
BEGIN
SELECT @mt_passage = max(mt_passage) FROM mvtTest WHERE ni_num = @ni_num AND pt_num=@pt_num AND mt_test=@mt_test AND mt_statut='NOGO'
END
ELSE
BEGIN
SET @mt_passage = 1
END
INSERT INTO defautTest
(
pt_num,
ni_num,
dt_lib,
mt_passage,
mt_test
)
VALUES
(
@pt_num,
@ni_num,
@dt_designation,
@mt_passage,
@mt_test
)
GO |
Partager