SELECT distinct m.LastName + ', ' + m.FirstName LastFirstName, m.LastName, m.FirstName, sr.userId FROM tbl_SYS_SavedReports sr WITH (NOLOCK) INNER JOIN dbo.tbl_SYS_Reports r WITH (NOLOCK) ON r.reportCode = sr.reportCode INNER JOIN tbl_FSPro_Members m WITH (NOLOCK) ON m.FSPro_Userid = sr.userId WHERE sr.OwnerId = AND sr.OwnerType = AND sr.temporary = 'N' GROUP BY r.reportTitle, sr.reportCode, sr.userReportName, sr.userId, m.FirstName, m.LastName ORDER BY m.LastName, m.FirstName for json path