I guess the ASP is listening for that record count returned from SQL, when the count comes back from one of the preliminary SELECT statements the ASP page continues processing, but no result set ...