How to Replace Null Values To 0 in Dynamic Pivot

Hi All,

I tried to convert the (null) values with 0 (zeros) output in dynamic PIVOT function but have no sucess.

i tried with below code but getting below error,

'SNULL' is not a recognized built-in function name.

DECLARE @columns NVARCHAR(MAX)
DECLARE @sql NVARCHAR(MAX);
SET @columns = N'';
SELECT   @Scolumns = ISNULL(@Scolumns + ',','')+ 'ISNULL(' + QUOTENAME(Name) + ', 0) AS '+ QUOTENAME(Name)--HERE AM GETTING ABOVE ERROR
  FROM (
		SELECT Name  FROM #Temp

   ) AS x;
SET @sql = N'
SELECT ' + STUFF(@columns, 1, 2, '') + '
FROM
(
  SELECT SaleQuantity,CONVERT(VARCHAR,YEAR(MonthOf))+''_''+DATENAME(MM,MonthOF) AS MonthNames  FROM TEST (NOLOCK)
  
) AS j
PIVOT
(
  SUM(SaleQuantity) FOR MonthNames IN ('
  + STUFF(REPLACE(@columns, ', p.[', ',['), 1, 1, '')
  + ')
) AS p;';
PRINT @sql;
EXEC sp_executesql @sql;

DROP TABLE #Temp

thanks in advance