drop table #FinalTable
drop table #ff
Create Table #FinalTable
(
InputID INT ,
PartNumber Nvarchar(500),
CompanyName nvarchar(500),
PartID int null,
DkFeatureId int,
PART_ID NVARCHAR(500),
ZfeatureId int,
[Value] nvarchar(4000),
Separator nvarchar(50),
SeparatorOrder int,
FeatureType int,
DKFeatureName nvarchar(100),
DisplayOrder int,
IsUnit int,
SeparatValue nvarchar(50),
Starformat nvarchar(50),
Endformat nvarchar(50),
DkFeatureName2 nvarchar(100),
StatusId int
)
insert into #FinalTable (InputID,PartNumber,CompanyName,PartID,PART_ID,DkFeatureId,ZfeatureId,StatusId,Separator,SeparatorOrder,Starformat,Endformat,FeatureType,Value,DKFeatureName,DisplayOrder,IsUnit,SeparatValue,DkFeatureName2
)
values
(124,'PIC32MZ2025DAR176-V/2J','Microchip Technology Incorporated',32106630,'12823269',724541,1500500006,3,'' ,1,NULL,NULL,2044,'32-Bit','Core Size',4,0,NULL,'Core Size (689)'),
(124,'PIC32MZ2025DAR176-V/2J','Microchip Technology Incorporated',32106630,'12823269',724541,1500500011,3,NULL,2,NULL,NULL,2044,'1','Core Size',4,0,NULL,'Core Size (689)'),
(128,'PIC32MZ2025DAS176-V/2J','Microchip Technology Incorporated',32106634,'12823241',724541,1500500006,3,'' ,1,NULL,NULL,2044,'32-Bit','Core Size',4,0,NULL,'Core Size (689)'),
(128,'PIC32MZ2025DAS176-V/2J','Microchip Technology Incorporated',32106634,'12823241',724541,1500500006,3,NULL,2,NULL,NULL,2044,'1','Core Size',4,0,NULL,'Core Size (689)'),
(141,'PIC32MZ2064DAS176T-V/2J','Microchip Technology Incorporated',32106647,'12823374',724541,1500500011,3,NULL,2,NULL,NULL,2044,'1','Core Size',4,0,NULL,'Core Size (689)'),
(141,'PIC32MZ2064DAS176T-V/2J','Microchip Technology Incorporated',32106647,'12823374',724541,1500500011,3,NULL,1,NULL,NULL,2044,'32-Bit','Core Size',4,0,NULL,'Core Size (689)')
--128 PIC32MZ2025DAS176-V/2J Microchip Technology Incorporated 32106634 7763416 46286 12823241 150 Microchip 150-PIC32MZ2025DAS176-V/2J-ND PIC32MZ2025DAS176-V/2J 32-BIT CACHE-BASED MCU, GRAPHICS Integrated Circuits (ICs) Embedded - Microcontrollers Active Non Stocking Exact V-Article_1582340902508557 14139 724541 1500500006 3 1 NULL NULL 2044 1423 32-Bit Core Size 4 32 0 NULL Core Size (689) 0 NULL NULL NULL
select * INTO #FF from (
SELECT DISTINCT
[InputID],PART_ID,partNumber,CompanyName,DKFeatureName2,IsUnit,
SUBSTRING((
SELECT isnull(StarFormat,'') + Value+ isnull(endFormat,'')
FROM #FinalTable
WHERE ([InputID] = Results.[InputID] and DkFeatureId = Results.DkFeatureId)
FOR XML PATH(''),TYPE).value('.', 'NVARCHAR(MAX)')
,1,5000) AS Value
FROM #FinalTable Results
where StatusId=3
)t
select * from #FF
InputID |
PART_ID |
partNumber |
CompanyName |
DKFeatureName2 |
IsUnit |
Value |
124 |
12823269 |
PIC32MZ2025DAR176-V/2J |
Microchip Technology Incorporated |
Core Size (689) |
0 |
32-Bit1 |
128 |
12823241 |
PIC32MZ2025DAS176-V/2J |
Microchip Technology Incorporated |
Core Size (689) |
0 |
32-Bit1 |
141 |
12823374 |
PIC32MZ2064DAS176T-V/2J |
Microchip Technology Incorporated |
Core Size (689) |
0 |
132-Bit |
I need PART_ID 12823374 and input id 141 value to be 32-Bit1
132-Bit is wrong
32-Bit1 is correct
so how to do that please