SQL Server 2017

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

CREATE TABLE [dbo].[Warehouse](
        [ID] [int] NOT NULL
        ,[Flag] [nvarchar](1) NULL
	,[ArtNo] [nvarchar](30) NOT NULL
	,[Amount] [float] NULL
) ON [PRIMARY]
INSERT INTO [dbo].[Warehouse]
           ([ID]
           ,[Flag]
           ,[ArtNo]
           ,[Amount])
     VALUES
           (1,'U','A1000',-100),
           (2,'U','B2000',-5),
           (3,'V','B2000',900),
           (4,'U','B2000',-10),
           (5,'I','B2000',50),
           (6,'U','B2000',-20),
           (7,'U','A1000',-50),
           (8,'I','A1000',1000),
           (9,'V','A1000',3600),
           (10,'U','A1000',-500),
           (11,'U','A1000',-100),
           (12,'U','A1000',-2000),
           (13,'I','A1000',2000),
           (14,'U','A1000',-1000),
           (15,'I','C3000',10000),
           (16,'U','C3000',-4000),
           (17,'U','B2000',-5),
           (18,'U','B2000',-5),
           (19,'I','B2000',40),
           (20,'V','B2000',200),
           (21,'U','A1000',-500),
           (22,'U','B2000',-50),
           (23,'U','C3000',-1000)
23 rows affected

SELECT * FROM [dbo].[Warehouse]


ID
Flag
ArtNo
Amount


1
U
A1000
-100

2
U
B2000
-5

3
V
B2000
900

4
U
B2000
-10

5
I
B2000
50

6
U
B2000
-20

7
U
A1000
-50

8
I
A1000
1000

9
V
A1000
3600

10
U
A1000
-500

11
U
A1000
-100

12
U
A1000
-2000

13
I
A1000
2000

14
U
A1000
-1000

15
I
C3000
10000

16
U
C3000
-4000

17
U
B2000
-5

18
U
B2000
-5

19
I
B2000
40

20
V
B2000
200

21
U
A1000
-500

22
U
B2000
-50

23
U
C3000
-1000

ID	Flag	ArtNo	Amount
1	U	A1000	-100
2	U	B2000	-5
3	V	B2000	900
4	U	B2000	-10
5	I	B2000	50
6	U	B2000	-20
7	U	A1000	-50
8	I	A1000	1000
9	V	A1000	3600
10	U	A1000	-500
11	U	A1000	-100
12	U	A1000	-2000
13	I	A1000	2000
14	U	A1000	-1000
15	I	C3000	10000
16	U	C3000	-4000
17	U	B2000	-5
18	U	B2000	-5
19	I	B2000	40
20	V	B2000	200
21	U	A1000	-500
22	U	B2000	-50
23	U	C3000	-1000