SQL Query combine text together in subquery

SQL QUERY:
Say I have 2 tables, 1 is a table containing start and end times. Say the other table contains notes.
I want to combine all the notes together for the notes entered within the start time and end time in a query.

Table A
TIMEID, BeginTime, EndTime, JobID
1             0700            0900         4
2             0900            1000          5
Table B
NoteID, CreatedTime, Note
1               0730              this is note 1
2               0830               This is note 2
3               0930                This is note 3

End Result would be
Begin Time, End Time,  JobID, Notes

0700 - 0900, 4, This is Note 1 This is Note 2
0900-1000, 5 This is note 3
BKennedy2008Asked:
Who is Participating?
 
Brian CroweDatabase AdministratorCommented:
You may need to adjust the boundary conditions depending on which end of the timespan you want to be inclusive.

SELECT BeginTime, EndTime, JobID,
   (
      SELECT Note + ' '
      FROM TableB
      WHERE CreatedTime >= A.BeginTime
         AND CreatedTime < A.EndTime
      ORDER BY CreatedTime
      FOR XML PATH('')
   ) AS Notes
FROM TableA AS A

Open in new window

0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
BKennedy2008, do you still need help on this question?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.