By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE [dbo].[DraftProducts](
[productCode] [varchar](20) NULL,
[phase] [varchar](50) NULL,
[name] [varchar](50) NULL,
[category] [varchar](20) NULL,
[description] [varchar](20) NULL,
[price] float NULL
)
CREATE UNIQUE CLUSTERED INDEX [DraftProductsIndex1] ON [dbo].[DraftProducts]
(
[productCode] ASC,
[phase] ASC
)
insert into DraftProducts (productCode,phase,name)
values
('p1',1,'aaaaaaaaaaaaaaa'),
('p2',2,'aaaaaaaaaaaaaaa'),
('p3',1,'aaaaaaaaaaaaaaa'),
('p2',15,'bbbbbbbbbbbbbbb'),
('p3',22,'bbbbbbbbbbbbbbb'),
('p1',8,'bbbbbbbbbbbbbbbbbbbbbbbbb'),
('p2',7,'ccccccccccccccc')
7 rows affected
select * from DraftProducts
/*
finish phase
p1=2
p2=15
p3=22
*/
| productCode | phase | name | category | description | price |
|---|---|---|---|---|---|
| p1 | 1 | aaaaaaaaaaaaaaa | null | null | null |
| p1 | 8 | bbbbbbbbbbbbbbbbbbbbbbbbb | null | null | null |
| p2 | 15 | bbbbbbbbbbbbbbb | null | null | null |
| p2 | 2 | aaaaaaaaaaaaaaa | null | null | null |
| p2 | 7 | ccccccccccccccc | null | null | null |
| p3 | 1 | aaaaaaaaaaaaaaa | null | null | null |
| p3 | 22 | bbbbbbbbbbbbbbb | null | null | null |