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
| CREATE PROCEDURE dbo.StoredProcedure1
@idpalonnier varchar(100),
@datetime datetime
AS
/* SET NOCOUNT ON */
DECLARE @numof varchar(50)
DECLARE Section_Cursor CURSOR FOR
SELECT Numof from ligne_chargement where id_palonnier = @idpalonnier
OPEN Section_Cursor
FETCH Section_Cursor INTO @numof
WHILE @@FETCH_STATUS = 0
BEGIN
UPDATE ordre_de_fabrication
SET date_lancement_OF = @datetime , quantite_of =( SELECT DISTINCT SUM(quantiteOF) AS Expr1
FROM ligne_chargement where Numof= @numof )
where id_ordre_de_fabrication = @numof
END
CLOSE Section_Cursor
DEALLOCATE Section_Cursor
RETURN |