Merge common rows in SQL Server

on Oct 27, 2021 10:45 PM

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