SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: July 2012

Joining on NULLs

A problem I see on a fairly regular basis is that of dealing with NULL values.  Specifically here, where we are joining two tables on two columns, one of which is ‘optional’ ie is nullable.  So something like this:

i.e. Lookup where all the columns are equal, even when NULL.  … Read more

5 comments, 1,711 reads

Posted in Dave Ballantynes blog on 26 July 2012