How to make a query with group_concat in sql server [duplicate]

by

Query:

SELECT
      m.maskid
    , m.maskname
    , m.schoolid
    , s.schoolname
    , maskdetail = STUFF((
          SELECT ',' + md.maskdetail
          FROM dbo.maskdetails md
          WHERE m.maskid = md.maskid
          FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 1, '')
FROM dbo.tblmask m
JOIN dbo.school s ON s.ID = m.schoolid
ORDER BY m.maskname

Additional information:

String Aggregation in the World of SQL Server

More Related Contents:

  1. Multiple rows to one comma-separated value in Sql Server [duplicate]
  2. Update a table using JOIN in SQL Server?
  3. What is the difference between varchar and nvarchar?
  4. SQL Server CTE and recursion example
  5. Calculate running total / running balance
  6. Unexpected variable type returned by Receive-Job
  7. CTE Recursion to get tree hierarchy
  8. List of all index & index columns in SQL Server DB
  9. Why use a READ UNCOMMITTED isolation level?
  10. How much size “Null” value takes in SQL Server
  11. Using a sort order column in a database table
  12. How to remove the time portion of a datetime value (SQL Server)?
  13. Is it possible to force row level locking in SQL Server?
  14. SQL Server String Concatenation with Null
  15. Preserving ORDER BY in SELECT INTO
  16. Select / Insert version of an Upsert: is there a design pattern for high concurrency?
  17. Is a single SQL Server statement atomic and consistent?
  18. SQL Server file names vs versions [closed]
  19. How to add xml encoding to xml Output in SQL Server
  20. What are the differences between a clustered and a non-clustered index?
  21. Unable to begin a distributed transaction
  22. Bulk insert with text qualifier in SQL Server
  23. How to migrate a PostgreSQL database into a SQLServer one?
  24. Multiple Column Pivot in T-SQL
  25. How to check SQL Server Database compatibility after sp_dbcmptlevel is deprecated?
  26. SQL SERVER PIVOT table with joins and dynamic columns
  27. SQL SERVER – Understanding how MIN(text) works
  28. How to convert text column to datetime in SQL
  29. SQL, How to Concatenate results?
  30. How to calculate difference in hours (decimal) between two dates in SQL Server?

Leave a Comment