I work on SQL server 2014 I need to rewrite update statement with best practice
CAN I Write it without subquery ?
UPDATE FFFFF
SET FamilyGroup = STUFF(
(
SELECT DISTINCT '|' + CAST( ISNULL(REPLACE(f.FamilyGroupText,'|','/'),'NULL') AS NVARCHAR(50))
FROM ExtractReports.dbo.MultiMask FF
INNER JOIN Parts.Nop_Part ptt WITH(NOLOCK) ON ptt.Masked_ID=ff.Masked_ID AND ptt.Masked_ID = FFFFF.Masked_ID
left JOIN [Parts].partscrubbing LC WITH(NOLOCK) ON ptt.PartID=LC.PartID
LEFT JOIN Parts.ZFamilyGroup f ON f.ID=LC.Generic_3
WHERE ff.Masked_ID=FFFFF.Masked_ID
FOR XML PATH ('')
),1,1,'')
FROM ExtractReports.dbo.MultiMask FFFFF