This project has moved and is read-only. For the latest updates, please go here.
1
Vote

CabCount = 0 search does not work.

description

The SQL for the CAB rollup code should account for the fact that the field may be NULL. A NULL should be replaced with a 0 before the comparison (or a check explicitly for null).
Need to use COALESCE(Count(*), 0) on the CR1, CR2 lines to get the CabCount as non null.
Then need to select from that table according to the CabCount criteria somehow.
 
Not a huge issue as most people will be searching for cabcount > n

comments