1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
|
SET @Idx = 1
WHILE (@Idx <= @Nombre_Copies)
BEGIN
INSERT INTO SOTRIGGERTAGHD(
TGTSYSTEMCOD, TGTDOCTYP, TGTPARAMVALUE, TGTCOPIESNB, TGTPRINTER,
TGTSHSTATUS, TGTUPDATEDDT, TGTPROG, TGTUSERCOD)
VALUES(
@Prefixe_Id_Etiquette + CAST(@No_Etiquette AS VARCHAR), @Type_Document, @Parametres, @Nombre_Copies, @Identifiant_Imprimante,
@Edition_Statut_Attente, GETDATE(), @Dialogue, @Operateur)
INSERT INTO SOTRIGGERDIALOGHD(TGDIPADDR, TGDMESSAGE, TGDSHSTATUS)
VALUES('127.0.0.1', @Prefixe_Id_Etiquette + CAST(@No_Etiquette AS VARCHAR), @Edition_Statut_Attente)
SET @Idx = @Idx + 1
END |
Partager