Merge common rows in SQL Server

ahmedsa
 
on Oct 27, 2021 10:45 PM
408 Views

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')
Download FREE API for Word, Excel and PDF in ASP.Net: Download
This question does not have answers.