if you are having trouble registering a dll on the server could you call an exe that creates a dbf of the result set, the name of which could be passed in as a parameter or left on a field in a shared table?
Slán
~M

>>how about:
>>

>>select count(trans.cTrans_pk) as iAccounts_Count, ;
>>	step1.cUsGrLink_pk, ;
>>	sum(trans.yCurrent_balance_amount) as yBalance ;
>>	from trans ;
>>	INNER join ;
>>	(select TEQ.cTrans_fk, ;
>>	iif(not isnull(TEQ.cCommission_Owner_UsGrLink_fk), ;
>>	TEQ.cCommission_Owner_UsGrLink_fk, ;
>>	TEQ.cUsGrLink_fk) as cUsGrLink_pk from Employee_Queue_Schedules EQS ;
>>	INNER join Trans_Employees_Queues TEQ ;
>>	on TEQ.cTrans_Employees_Queues_pk = EQS.cTrans_Employees_Queues_fk ;
>>	where TEQ.iActive_Flag = 1 ;
>>	and EQS.iActive_Flag = 1  and ;
>>      and EQS.tScheduled_time <= m.ltTime
>>	iif(not isnull(TEQ.cCommission_Owner_UsGrLink_fk), .t., ;
>>	(TEQ.iTemporary_Assignment_Flag = 1 and ;
>>	TEQ.tStart_Date <= m.ltTime and ;
>>	TEQ.tExpire_Date >= m.tdDate))) step1 ;
>>	on trans.cTrans_pk = step1.cTrans_fk ;
>>	where trans.cResolution_Codes_fk is null ;
>>	group by 2 into cursor (m.tcAlias) readwrite
>>

>>with making sure that there is an index on step1.cUsGrLink_pk and
>>on TEQ.cTrans_Employees_Queues_pk and
>>on EQS.cTrans_Employees_Queues_fk and
>>on TEQ.iActive_Flag
>We don't have indexes on iActive_Flag (it's integer field 1/0). We have other indexes. The Step1 is created on the fly, so it doesn't have indexes. I can create it as a separate step and create an index on it.
>
>The other idea we have is to create DLL on the server to retrieve data. I would have to return it as XML. The resulting file should have ~350 records and 2 fields, so I don't think CursorToXML/XMLToCursor would be slow.
>
>But we're having problem registering DLL on the server.