Loading

String_Agg is duplicating its values ...Please Help

Bidzina Goginashvili

7y6.2k

In this table i have a Parentname and Subname columns and in this case given Parentnames is the parent of given Subnames

i was trying to do something like this:

STRING_AGG(ISNULL(Distinct ch.Name, ' '), '; ') ParentName

but it is getting error..Any Solutions?I dont want to duplicate this Parentname. i want it to be only one.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Kumar7y ago
Hi, In this case you should use COALESCE() function . The COALESCE function in SQL returns the first non-NULL expression among its arguments. syntax for COALESCE is as follows: COALESCE ("expression 1", "expressions 2", ...) For more details refer: https://www.1keydata.com/sql/sql-coalesce.html
Mohsin Arif7y ago
hi
read this article
https://docs.microsoft.com/en-us/sql/t-sql/functions/string-agg-transact-sql?view=sql-server-2017