i am having trouble stuffing the date and time for the same item in SQL sever. Below are three simple records.
Date_Time ID
9/6/2018 5:36:30 PM 12345
9/6/2018 6:19:02 PM 12345
9/7/2018 4:15:55 AM 12345
I would like my result to be in 1 row and the Date_Time column got stuffed followed by a comma (,).
Date_Time ID
9/6/2018 5:36:30 PM, 9/6/2018 6:19:02 PM, 9/7/2018 4:15:55 AM 12345
Would someone please point me to the right direction/link or a simple query to resolve the issue?
Thanks, XH.
If you are using sql server 2017 or above you can use string_agg as below:
If it is below sql server 2017 you can use below query:
On MySQL
SELECT id, group_concat(Date_Time) as test FROM TABLE_NAME GROUP BY ID