Please help. I'm trying to concatenate the notes by SequenceNo and group by RecControlID and EmpNo.
Before:
After:
Asked
Active
Viewed 78 times
0
marc_s
- 704,970
- 168
- 1,303
- 1,425
ComfortablyNumb
- 19
- 1
- 4
-
Click the links for the images. I do not know how to embed the pics. – ComfortablyNumb Jun 23 '17 at 15:54
-
How did this problem come about?Why not just select the Max(Note) if they are going to be duplicated – S3S Jun 23 '17 at 15:56
-
The actual notes are not duplicated, only the example. I used the same sentence(s) to save time. – ComfortablyNumb Jun 23 '17 at 16:10
-
Caps lock doesn't help clarify your question.... – S3S Jun 23 '17 at 16:11
-
I've updated the 'After' removing the Sequence column. – ComfortablyNumb Jun 23 '17 at 19:13
-
This will help, but you're going to have to find a way to distinguish between sets of groups: https://stackoverflow.com/questions/17591490/how-to-make-a-query-with-group-concat-in-sql-server – S3S Jun 23 '17 at 19:16