I work on sql server 2012 i need to get featurekey and feature value separated $ Based on partid but i don't know how o do that by select sql query ? expected result as below
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')