Quote:'STRING_AGG' is not a recognized built-in function name.
Quote:SELECT distinct n.ID,n.brandName,n.requestType, n.services,dm.department as department,aos.levelName as level, STRING_AGG(pu.firstName+' '+pu.lastName,',') as fullName FROM Notification n INNER JOIN DepartmentMaster dm on dm.departmentID=n.department INNER JOIN NotificationUser nu ON n.ID=nu.fk_notification_id INNER JOIN ProfileUser pu ON pu.userID=nu.userID INNER JOIN AopLevel aos on aos.levelID=n.level where n.ID=nu.fk_notification_id group by n.ID, n.brandName,n.requestType,n.services,dm.department,aos.levelName
Quote:On production I have SQL Server 2016 running and had to work on alternative for STRING_AGG which is not supported on older version
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)