Display products details in separate year column in SQL Server

Question

Hi I used this Merge multiple rows based on id and display in one row using SQL Server But I want show result belowIn ProductTable I have Parametr for define year Only for DatePlanNext Parametr is 1 for other is 0 How I can get below result  IdPREDATEPREPRODUCTDateSallerNameDatePlanNextNextProduct109092015Melon  09092017Melon209102016Potato    310102016Tomato10102017Tomato  4  09092017Cucumber  5  12112017Onion12112018Onion607022016Cherry

AnandM · Accepted Answer

Hi  FiruzThe Data and Output you provided is wrong because of it the actual output was not coming as exceptedBelow is the correct data and actual output you wantedRefer below SQL QuerySQLDECLARE ProductTable AS TABLEId INT IDENTITY11IdProduct INTDateSaller DATETIMEName VARCHAR50DatePlanNext DATETIMEParametr int    INSERT INTO ProductTableIdProductNameDatePlanNextParametr VALUES139Onion393909092018391INSERT INTO ProductTableIdProductDateSallerNameParametr VALUES239020720163939Cherry390INSERT INTO ProductTableIdProductDateSallerNameParametr VALUES339090920153939Melon390INSERT INTO ProductTableIdProductDateSallerNameParametr VALUES439100920163939Potato390INSERT INTO ProductTableIdProductDateSallerNameParametr VALUES539101020163939Tomato390INSERT INTO ProductTableIdProductNameDatePlanNextParametr VALUES539Tomato393909092017391

Display products details in separate year column in SQL Server

Company

Explore

Follow us

Contact Us

Id	PREDATE	PREPRODUCT	DateSaller	Name	DatePlanNext	NextProduct
1	09.09.2015	Melon			09.09.2017	Melon
2	09.10.2016	Potato
3	10.10.2016	Tomato	10.10.2017	Tomato
4			09.09.2017	Cucumber
5			12.11.2017	Onion	12.11.2018	Onion
6	07.02.2016	Cherry