SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE src ( Id INT, Qty INT, ItemWgt INT )
INSERT INTO src values ( 1, 3,   10)
                     , ( 2, 4,   11)
                     , ( 3, 5,   12)
                     , ( 4, 4,   13)
                     , ( 5, 4,   10)
                     , ( 6, 1,   90)
                     , ( 7, 2,   23)
                     , ( 8, 12,   8)
                     , ( 9, 13,   9)
                     , ( 10, 5,  20)
                     , ( 11, 6,  60)
                     , ( 12, 4,  64)
                     , ( 13, 1,  32)
                     , ( 14, 2,  20)
                     , ( 15, 12, 40)
15 rows affected

Declare @MaxPartWgt Int = 100;
WITH 
cte AS (SELECT Id
             , Qty
             , ItemWgt
             , Sum( Qty * ItemWgt) over ( order by Id) as OverWgt
             , Sum( Qty * ItemWgt) over ( order by Id) / @MaxPartWgt + 1 as NumberPartWgt
         FROM src )
select Id
     , Qty
     , ItemWgt
     , OverWgt
     , NumberPartWgt
     , Sum( Qty * ItemWgt) over( partition by NumberPartWgt order by Id ) as xOverWgt
FROM cte
ORDER BY id ASC;


Id
Qty
ItemWgt
OverWgt
NumberPartWgt
xOverWgt


1
3
10
30
1
30

2
4
11
74
1
74

3
5
12
134
2
60

4
4
13
186
2
112

5
4
10
226
3
40

6
1
90
316
4
90

7
2
23
362
4
136

8
12
8
458
5
96

9
13
9
575
6
117

10
5
20
675
7
100

11
6
60
1035
11
360

12
4
64
1291
13
256

13
1
32
1323
14
32

14
2
20
1363
14
72

15
12
40
1843
19
480

Id	Qty	ItemWgt	OverWgt	NumberPartWgt	xOverWgt
1	3	10	30	1	30
2	4	11	74	1	74
3	5	12	134	2	60
4	4	13	186	2	112
5	4	10	226	3	40
6	1	90	316	4	90
7	2	23	362	4	136
8	12	8	458	5	96
9	13	9	575	6	117
10	5	20	675	7	100
11	6	60	1035	11	360
12	4	64	1291	13	256
13	1	32	1323	14	32
14	2	20	1363	14	72
15	12	40	1843	19	480