Hello all! I have a SQL Select statement storing the results to a temp table. When the Select statement runs and doesn't return any results, _TALLY is returning 1. Has anyone seen this before? Can anyone tell me why this is happening? If I store the contents to a cursor _TALLY returns the correct value, but I have to use a table because of other processing that follows.

TIA!