SQL, How to Concatenate results?

by

With MSSQL you can do something like this:

declare @result varchar(500)
set @result=""
select @result = @result + ModuleValue + ', ' 
from TableX where ModuleId = @ModuleId

More Related Contents:

  1. SQL comma-separated row with Group By clause
  2. Insert an image in a column of a table that already has 5 columns
  3. Get top 1 row of each group
  4. How to use GROUP BY to concatenate strings in SQL Server?
  5. Referring to a Column Alias in a WHERE Clause
  6. Convert Month Number to Month Name Function in SQL
  7. How to avoid the “divide by zero” error in SQL?
  8. SET versus SELECT when assigning variables?
  9. Is there any difference between IS NULL and =NULL
  10. Generate a resultset of incrementing dates in TSQL
  11. Real life example, when to use OUTER / CROSS APPLY in SQL
  12. Getting result of dynamic SQL into a variable for sql-server
  13. How to get difference between two rows for a column field?
  14. Better techniques for trimming leading zeros in SQL Server?
  15. How to print VARCHAR(MAX) using Print Statement?
  16. SQL statement to select all rows from previous day
  17. What’s the best way to select the minimum value from several columns?
  18. Splitting delimited values in a SQL column into multiple rows
  19. How to insert a blob into a database using sql server management studio
  20. SQL GROUP BY CASE statement with aggregate function
  21. separate comma separated values and store in table in sql server
  22. Best way to do nested case statement logic in SQL Server
  23. How to check which locks are held on a table
  24. Execution sequence of Group By, Having and Where clause in SQL Server?
  25. SQL Script to alter ALL Foreign Keys to add ON DELETE CASCADE
  26. Is it possible to execute a text file from SQL query?
  27. Use variable with TOP in select statement in SQL Server without making it dynamic [duplicate]
  28. SQL query to group by day
  29. How do I find the data directory for a SQL Server instance?
  30. Compare dates in T-SQL, ignoring the time part

Leave a Comment