SQL Server: combining multiple rows into one row

by

There are several methods.

If you want just the consolidated string value returned, this is a good quick and easy approach

DECLARE @combinedString VARCHAR(MAX)
SELECT @combinedString = COALESCE(@combinedString + ', ', '') + stringvalue
FROM jira.customfieldValue
WHERE customfield = 12534
    AND ISSUE = 19602

SELECT @combinedString as StringValue

Which will return your combined string.

You can also try one of the XML methods e.g. 

SELECT DISTINCT Issue, Customfield, StringValues
FROM Jira.customfieldvalue v1
CROSS APPLY ( SELECT StringValues + ',' 
              FROM jira.customfieldvalue v2
              WHERE v2.Customfield = v1.Customfield 
                  AND v2.Issue = v1.issue 
              ORDER BY ID 
                  FOR XML PATH('') )  D ( StringValues )
WHERE customfield = 12534
    AND ISSUE = 19602

More Related Contents:

  1. Comma separated results in SQL
  2. How to check if a column exists in a SQL Server table
  3. Understanding PIVOT function in T-SQL
  4. Using T-SQL, return nth delimited element from a string
  5. Get first day of week in SQL Server
  6. Using RegEx in SQL Server
  7. How do you view ALL text from an ntext or nvarchar(max) in SSMS?
  8. Confused about UPDLOCK, HOLDLOCK
  9. INSERT INTO vs SELECT INTO
  10. SQL Server 2008 Empty String vs. Space
  11. How do I use the CONCAT function in SQL Server 2008 R2?
  12. How to set a default value for an existing column
  13. Select / Insert version of an Upsert: is there a design pattern for high concurrency?
  14. TSQL: How to convert local time to UTC? (SQL Server 2008)
  15. How do I find a stored procedure containing ?
  16. SQL Recursive CTE: Finding objects linked by property
  17. How to convert number of minutes to hh:mm format in TSQL?
  18. Convert decimal time to hours and minutes
  19. SQL Server 2008 – How do i return a User-Defined Table Type from a Table-Valued Function?
  20. How do I move a table into a schema in T-SQL
  21. Instead of trigger in SQL Server loses SCOPE_IDENTITY?
  22. How Can I Detect and Bound Changes Between Row Values in a SQL Table?
  23. How to wait for 2 seconds?
  24. What are row, page and table locks? And when they are acquired?
  25. Generate MD5 hash string with T-SQL
  26. best way to convert and validate a date string
  27. SQL Server Query: Fast with Literal but Slow with Variable
  28. SQL Server, the misleading XLOCK & optimizations
  29. “Prevent saving changes that require the table to be re-created” negative effects
  30. @@ERROR and/or TRY – CATCH

Leave a Comment