Merging multiple rows to one by replacing null values in SQL Server

PRA

SOLVED CLOSED ACTIVE ANSWERED
User: PRA
Posted: on Jul 25, 2017 10:26 AM
Forum: SQL Server
Answer: 2
Views: 3971

Hi! I have two table person and product. I want show result each person in one row from two rows in SQL

Id	Name
1	Rustam
2	Firuz
3	Asror
4	Nurullo

Id	IdPerson	Food	Fruit	Vegetable	Water
1	1	oil	apple
2	1			tomato	RC-cola
3	2	oil	apple
4	2			tomato	RC-cola
5	3	oil	apple
6	3			tomato	RC-cola

For example: out result:

Id	Person	Food	Fruit	Vegetable	Water
1	Rustam	oil	apple	tomato	RC-cola
2	Firuz	oil	apple	tomato	RC-cola
3	Asror	oil	apple	tomato	RC-cola

Download FREE API for Word, Excel and PDF in ASP.Net

itsjaysh...

0 3

Reply
ANSWER
User: itsjayshah
Replied: on Jul 26, 2017 04:12 AM
Report

SELECT IdPerson
       ,MAX(Food) AS Food
       ,MAX(Fruit) AS Fruit
       ,MAX(Vegetable) AS Vegetable
       ,MAX(Water) As Water 
FROM Table_2 
GROUP BY IdPerson

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Merging multiple rows to one by replacing null values in SQL Server

Company

Explore

Follow us

Contact Us