HiI have two tables in SqlFruitsIdName1Apple2Banana3CherryPersonIdName1Rustam2Muhammad3Sindbod4Sadriddin ProductsIdPersonIdFruitId113412123322 Now I want below resultOutput resultIdNamePersonFruit1Rustam Sindbod SadriddinApple2Rustam MuhammadCherry3MuhammadBanana

ReferReplace comma separated ItemCode with ItemName using Stuff function in SQL Server

Replace (Change) comma separated Value with Text in SQL Server

PRA

Hi!

I have two tables in Sql.

Fruits

Person

Products

Now I want below result.

Output result:

dharmend...

0 1

Refer:

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