Returning multiple rows as one row

Question

Here is a simple query and it's results using SQL Server:

SELECT Notes
FROM DailyTaskHours
WHERE Notes IS NOT NULL
    AND Notes <> ''
    AND NonScrumStoryId = 2264

I would like one row with one column returned. How do I accomplish this?

Answer 1

If this is a SQL Server Database I believe you can implement the PIVOT operator in a way like this:

select [1] as field1,
  [2] as field2,
  [3] as field3
from
(
  select col1, row_number() Over(order by col1) rn
  from yourtable
) src
pivot
(
  max(col1)
  for rn in ([1], [2], [3])
) piv

Answer 2

I'm figuring you need them all as a single cell, rather than PIVOT them out.

Try this

With 
MyTable as
(
        Select 1 Id, 'Contacted the P6 Admin Reps to find out what to do.' Notes
Union   Select 2, 'Sent and email to request status.'
Union   Select 3, 'updated ticket and confirmed issue was resolved.'
) 
Select 
    (
        SELECT SUB.Notes + ' ' 
        FROM MyTable SUB
        FOR XML PATH('')
    ) TextValue 

Here is the answer I get:

TextValue
---------------------------------------------------------------------------------------------------------------------------------------
Contacted the P6 Admin Reps to find out what to do. Sent and email to request status. updated ticket and confirmed issue was resolved. 

(1 row(s) affected)