Concatenate all values in a column

 If you looking to concatenate the values of a column in sql server the below technique helped.

Table NC:

Table NCAssociated:

Final Output:

The below query in SQLServer was helpful:

     select nc.NCId,nc.NCNumber,

         (

         SELECT STRING_AGG(CONVERT(VARCHAR(200), NCAO.AssociatedNCNumber), ', ') 

         FROM 

              (

           select nca.NCId, NCA.AssociatedNCId, nci.NCNumber AssociatedNCNumber

                 From dbname.schemaname.NCAssociated nca INNER JOIN  dbname.schemaname.NC nci

                   ON   NCi.NCId=NCA.AssociatedNCId

             WHERE  NCA.NCId= nc.NCId 

           ) NCAO

        ) AssociatedNCNumber

  from dbname.schemaname.NC nc

 order by nc.NCId