Hi Kevin,

The EMPTY() function isn't Rushmore optimizable and I don't think you need NOT in WHERE clause.

SELECT BatchId, Id, EntryDate, TranDate, EntityId, Count(*) AS Cnt ;
  FROM Resh ;
  WHERE Resh.Status = SPACE(nn) ;
  GROUP BY BatchId, Id, EntryDate, TranDate, EntityId;
  ORDER BY Resh.BatchId ;
  INTO CURSOR Temp1

>I have a table where each record belongs to a batch.
>
>I need to pull a count of how many records are in each batch
>that have not had the status field set.
>
>I have:
>
>

>USE d:\projects\testdata\smts\resh.DBF
>
>SELECT BatchId, Id, EntryDate, TranDate, EntityId, Count(*) AS Cnt ;
>  FROM Resh ;
>  WHERE NOT EMPTY(Resh.Status ;
>  GROUP BY BatchId, Id, EntryDate, TranDate, EntityId;
>  ORDER BY Resh.BatchId ;
>  INTO CURSOR Temp1
>

>
>This does not correctly give back the counts, and its very slow.
>
>Anyone know how to do this?
>
>Thanks