I have Query Custom PIVOT
SET @DateList = STUFF((SELECT ',[' + CONVERT(NVARCHAR( 50),ListName) + ']' FROM List ORDER BY sort FOR XML PATH('')),1,1,'')
SET @SQL= ' SELECT * FROM (SELECT * FROM Result )m PIVOT(SUM(Value) FOR ListName IN (' + @DateList + '))n '
EXEC(@SQL)
the result table contain some column is null
i need repalce column is null to any value