Query length

  

Hi,


has anybody experience something like this: 

Query returns length 2 and count 4 ..  ? Anybody ideas? 


Thanks Sam

The Query.Count is the total number of records in the DB.

Internally is a different query that's executed.

Query.Length is the actual number of records fetched from the DB.

João Heleno wrote:

The Query.Count is the total number of records in the DB.

Internally is a different query that's executed.

Query.Length is the actual number of records fetched from the DB.

actual query :SELECT TOP (32) ENCandidate.[ID] o0, ENCandidate.[NAME] o1, ENCandidate.[LINKEDINURL] o2, ENCandidate.[COMPANYNAME] o3, ENCandidate.[PICTUREURL] o4, ENCandidateEvent.[ID] o5, ENCandidateEvent.[CANDIDATEID] o6, ENCandidateEvent.[EVENTID] o7, ENCandidateEvent.[FEEDBACKTYPEID] o8, ENCandidateEvent.[FEEDBACKCOMMENT] o9FROM ([OSDEV1].DBO.[OSUSR_2FR_CANDIDATEEVENT] ENCandidateEventInner JOIN [OSDEV1].DBO.[OSUSR_2FR_CANDIDATE2] ENCandidate ON (ENCandidateEvent.[CANDIDATEID] = ENCandidate.[ID])) WHERE ((ENCandidate.[ID] <> @Candidate_Id) OR (ENCandidate.[ID] IS NULL)) AND ((ENCandidateEvent.[EVENTID] = @CandidateEvent_EventId) AND (ENCandidateEvent.[EVENTID] IS NOT NULL))ORDER BY ENCandidate.[NAME] ASC 


which means top 32.. returns only 2 , and count is 4 ? Still makes nog sense to me..