Thanks Jeffrey Williams and Jeff Moden.

The query works for my data.

Hi @jeff Moden, @Jeffrey Williams,

Is there any way to achieve this through STUFF() function. Since I am having SQL server 2014.

Thanks

Hi @jcelko212 32090

This is my first post and sorry for that I dint posted DDL query. I am using the constraints while creating tables. This is the sample data which...

• This reply was modified 4 years, 2 months ago by  Harry.

Hi @jeff Moden,

Thank you information, I will follow that. I am newbie here.

I am having SQL Server 2014. So that, STRING_AGG function is not working. I have posted wrongly...