Never mind. If I remove TOP 180, it still returns just 48 records. Weird.

>Hi everybody,
>
>Do you know why this code
>

>* Get the unassigned accounts
>	SELECT TOP m.lnNumAccounts TRANS.cTrans_Pk, ;
>		Trans_Employees_Queues.cTrans_Employees_Queues_Pk, 0 AS iAssigned, ;
>		SPACE(16) AS cCommission_Owner_UsGrLink_fk, ;
>		SPACE(16) AS cqueue_names_fk ;
>		FROM mmVisCollect!TRANS INNER JOIN mmVisCollect!Trans_Employees_Queues ;
>		ON TRANS.cTrans_Pk = Trans_Employees_Queues.cTrans_fk ;
>		WHERE ISNULL(Trans_Employees_Queues.cCommission_Owner_UsGrLink_fk) ;
>		AND Trans_Employees_Queues.cqueue_names_fk = m.lcQueue_Names_Fk ;
>		ORDER BY TRANS.tDate_Received ;
>		INTO CURSOR curAccounts READWRITE

>
>would return only 48 records when lnNumAccounts = 180?
>
>Thanks in advance.