Adding Numeric value and Null 1

[Robinstwitcher]

Am attempting to update a table by adding a value from one table into a table that currently contains Null.
current code is:

UPDATE table1
SET NrofRows = a.NrOfRows + b.NrOfRows
FROM table1 a, table2 b
WHERE a.Key = b.Key


The Values contained are
table1 NrOfRows = Null
table2 NrOrRows = 1000

The answer returned is Null - Can you help please!

 

[SQLDenis]

UPDATE table1
SET NrofRows = coalesce(a.NrOfRows,0) + coalesce(b.NrOfRows,0)
FROM table1 a, table2 b
WHERE a.Key = b.Key

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/