Hi Support,

I have a reporting query.

Could you please help me to create a MSSQL script to list Request ID's and a combined string of the Support Group names which have owned the Request at any time.

I would also like to include a date range within the Where clause. For example Requests logged between '2017-10-01 00:00:00.000' and '2017-10-31 23:59:59.998'

E.g.

Request ID Support Groups

121122 Support Group 1, Support Group 4

121123 Support Group 1, Support Group 2

121124 Support Group 1, Support Group 3, Support Group 5

121125 Support Group 2

121126 Support Group 1, Support Group 5

I would like the Support Group names to be comma separated in a single column and I would like to avoid dupicates names, so if 'Support Group 1' was the owner on multiple occasions, it would only appear in the string once.

I'm using version 9.2 (build 9241) with a MSSQL 2008 database.

I look forward to hearing from you.

Kind regards,

Greg