[Solved] How to handle NULL’s to show 0 in T-SQL query

This should work:

SELECT cast(COALESCE(sum([ColumnA]), 0) as DECIMAL(18,0)) AS [Weight] 
FROM [DB1].[dbo].[Tabel1]