>>Ok, as long as you have it working...
>>
>
>
>
>Not really - too much data is transferred - he needs only a portion of it
>
>
>>Although what if you select into TQuery rather than 'sql' and comment out the select following SQLEXEC statement?

I agree, but I can not understand where exactly the problem lies. Is it just a matter of adding the parameter back to SP to get only relevant data?