I work on sql server 2012 i need to get featurekey and feature value separated $ Based on partid but i don't know how to do that by select sql query?
expected result as below
PartId |
Featurekey |
FeatureValue |
1550 |
Botato$Mango$dates |
Yellow$Red$Black |
1600 |
Rice$macrona$chicken |
white$Red$Yellow |
1700 |
Guava$grapes$FIG |
Yellow$Green$Red |
create table #PartsFeature
(
PartId int,
Featurekey nvarchar(200),
FeatureValue nvarchar(200),
)
insert into #PartsFeature(PartId,Featurekey,FeatureValue)
values
(1550,'Botato','Yellow'),
(1550,'Mango','Red'),
(1550,'dates','Black'),
(1600,'Rice','white'),
(1600,'macrona','Red'),
(1600,'chicken','Yellow'),
(1700,'Guava','Yellow'),
(1700,'grapes','Green'),
(1700,'FIG','Red')