Hello All,
The db is SQL Server 2005.
I have the following data in a temp table. What I'm trying to accomplish is to concatenate the CourseCode for OrderID = 111111 so that the CourseCode will be something like HRD8319,PSY8875
OrderID CourseCode ProductID
111111 HRD8319 42617
111111 PSY8875 42629
The desire result is as follow
OrderID CourseCode
111111 HRD8319,PSY8875
Is this possible? Any suggestion/input is greatly appreciated.
Thanks in advance
The db is SQL Server 2005.
I have the following data in a temp table. What I'm trying to accomplish is to concatenate the CourseCode for OrderID = 111111 so that the CourseCode will be something like HRD8319,PSY8875
OrderID CourseCode ProductID
111111 HRD8319 42617
111111 PSY8875 42629
The desire result is as follow
OrderID CourseCode
111111 HRD8319,PSY8875
Is this possible? Any suggestion/input is greatly appreciated.
Thanks in advance