SQL Server 2019

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

select @@version;


(No column name)


Microsoft SQL Server 2019 (RTM-CU16) (KB5011644) - 15.0.4223.1 (X64) 
 Apr 11 2022 16:24:07 
 Copyright (C) 2019 Microsoft Corporation
 Express Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor)



CREATE TABLE TheTable (
Id int PRIMARY KEY,
Version int,
Item_No int NOT NULL,
Notes varchar(50)
);
INSERT INTO TheTable VALUES
(1, null, 31, null),
(2, 1, 31, 'tasty'),
(3, 2, 31, 'kinda tasty'),
(4, null, 32, null),
(5, 1, 32, 'meh'),
(6, 2, 32, 'alright'),
(7, 3, 32, 'fabulous'),
(8, null, 33, 'ambivalent'),
(9, 1, 33, 'gross'),
(10, 2, 33, 'puke');
10 rows affected

SELECT * FROM TheTable


Id
Version
Item_No
Notes


1
null
31
null

2
1
31
tasty

3
2
31
kinda tasty

4
null
32
null

5
1
32
meh

6
2
32
alright

7
3
32
fabulous

8
null
33
ambivalent

9
1
33
gross

10
2
33
puke

Id	Version	Item_No	Notes
1	null	31	null
2	1	31	tasty
3	2	31	kinda tasty
4	null	32	null
5	1	32	meh
6	2	32	alright
7	3	32	fabulous
8	null	33	ambivalent
9	1	33	gross
10	2	33	puke