Merge row SQL

SELECT
sc.CategoryID,
sc.CategoryCode,
sc.CategoryName,
sc.Status,
UserCreated,
UserModified,
sc.Description,
sc.DisplayOrder,
sc.CreatedDate,
sc.ModifiedDate,
SUBSTRING(
(
SELECT ', ' + S.ServicesName AS [text()]
FROM Sales.Sale_CategoryService ST1
INNER JOIN Core.Core_Service S ON ST1.ServiceId = S.ServiceID
WHERE sc.CategoryId = ST1.CategoryId
ORDER BY ST1.CategoryId
FOR XML PATH ('')
), 2, 1000) ServiceNames,
SUBSTRING(
(
SELECT ', ' + CAST(S.ServiceID AS VARCHAR(10))AS [text()]
FROM Sales.Sale_CategoryService ST1
INNER JOIN Core.Core_Service S ON ST1.ServiceId = S.ServiceID
WHERE sc.CategoryId = ST1.CategoryId
ORDER BY ST1.CategoryId
FOR XML PATH ('')
), 2, 1000) ServiceIds

    FROM Sales.Sale_Category sc