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

by


This should work:

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

0

solved How to handle NULL’s to show 0 in T-SQL query