• not fully understood

    using the above i am not getting any records

    but in query analyser i get 100 records with date condition & id condition