Updating using 2 tables with sql dating canada pen friends for2 | 22 from 01 08 2003 / 23 from 02 08 2003 / | | 3 |
Let's look at what SQL Server says about temporary tables.
exists only for the duration of a user session or the procedure that created the temporary table.
When the user logs off or when the procedure that created the table completes, the local temporary table is lost.
works fine when I try to update all the records in tbl A, however, in this case I only have missing data which I have identified and populated in tbl B.
When I try to update only the missing data the non-matched data is also updated but to NULL. The reason some of your rows are getting NULLs updated is due to the subquery.