Ok, I went ahead and re-coded. Your solution is less lines of code, so presumably it would be faster.

>What about:
>
>
>

>lcFrom  = 'v_QuickSearch'
>SELECT myView.*, ;
>		IIF(EMPTY(myView.cResolution_Codes_Fk) OR ;
>		ISNULL(myView.cResolution_Codes_Fk), ;
>		myView.cStatus_Codes_Fk, ;
>		myView.cResolution_Codes_Fk) AS cVisCodes_Fk, ;
>		Employee_queue_schedules.cemployee_queue_schedules_pk, USERS.cUserID ;
>		FROM (lcFrom) as myView ;
>		INNER JOIN mmVisCollect!Trans_employees_queues ;
>		ON myView.cTrans_PK = Trans_employees_queues.ctrans_fk ;
>		INNER JOIN mmVisCollect!usgrlink ;
>		ON  Trans_employees_queues.ccommission_owner_usgrlink_fk = usgrlink.cusgrlink_pk ;
>		INNER JOIN mmVisCollect!Employee_queue_schedules ;
>		ON  Trans_employees_queues.ctrans_employees_queues_pk = Employee_queue_schedules.ctrans_employees_queues_fk ;
>		INNER JOIN mmVisCollect!USERS ;
>		ON  USERS.iid = usgrlink.iuserid;
>		WHERE Trans_employees_queues.iactive_flag =  1 ;
>		AND  Employee_queue_schedules.iactive_flag =  1 ;
>		INTO CURSOR cTempResult
>