1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| DECLARE @MyCounter bigint
DECLARE @ActualWeightDIMS varchar(50)
DECLARE @MyI bigint
SET @MyI=1
SET @MyCounter =(SELECT top 1 (WAGENBARCODE) FROM CPS_VSWAGEN WHERE WAGENBARCODE like ''+PARAM1+'%' order by WAGENBARCODE DESC )
SET @MyCounter =@MyCounter+1
WHILE @MyI <= 10
BEGIN
SET @ActualWeightDIMS = 'Palette'+ cast(@MyCounter as varchar(20))
INSERT INTO CPS_VSWAGEN (WAGENBARCODE ,BEZEICHNUNG1 , ENTEREDBY ,ENTRYDATE, LASTUSER , LASTCHANGE, EDITUSER, EDITSTATUS,ANZAHLELEMENTE, EIGENTUEMER , STATUS, LIEFERANT )
VALUES ( @MyCounter ,@ActualWeightDIMS,1107 ,GETDATE(),1107 ,GETDATE() , 0 ,0 ,20 ,0 ,1 , 0 )
SET @MyCounter = @MyCounter + 1
SET @MyI = @MyI + 1
END; |
Partager