Pivot data horizontally based on feature name and feature value

[yosiasz]

You need to respond to respond yo this 1st

How to avoid using string aggreagte for give unique numbers for every group of numbers?

I work on sql server 2019 i face issue i need to give unique number to every group of numbers without using string aggreagte or stuff original table as below create table #parts ( PartNumber varchar(50), PartValue int, UniqueNumber int ) insert into #parts(PartNumber,PartValue,UniqueNumber) values ('P1',1,NULL), ('P1',2,NULL), ('P1',3,NULL), ('P1',4,NULL), ('P2',1,NULL), ('P2',2,NULL), ('P3',1,N…