In this stored procedure statement:

if (exists(select 1 from HOLIDAYS where ADate>=DSTART and AData<=DEND))
then begin
.....
end

Question:

Does the select statement step through all records which meet the condition
or does it return immediately after the first occurance of the condition?

TIA,
--
Bambang P.