حضرت خواجہ سیدنا معین الدین حسن چشتی سنجاری اجمیری رحمۃ اللہ علیہ

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

PRA

PRA

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

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

Andrea

Andrea

0 1

Reply
User: Andrea
Replied: on Jul 25, 2017 10:26 AM
Report

Hi @PRA, Please try the following Select Query to get child rows from a table having parent-child relationship in SQL Server It might help you. Cheers Andrea.

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

Contact Us

Email: webmaster@aspsnippets.com
Address:
ASPSNIPPETS PRIVATE LIMITED
G-110, SHAGUN ARCADE,
MALAD (EAST),
MUMBAI, MAHARASHTRA,
INDIA 400097.

© COPYRIGHT 2025 ASPSnippets.com ALL RIGHTS RESERVED.