Maybe I'm confused. It looked to me like you were sending the query and related data (constraints) to a stored procedure for the proc to execute it as Dynamic SQL? If this is the case, I don't see any reason for the proc. It's not realizing any benefits.
Did I miss something?
-Mike
>>At this point, what do you gain by trying to push this into a stored proc? I see no benefit. You might as well just execute the ad-hoc query directly instead of hiding it within the stored proc.
>>
>>-Mike
>
>I guess I'm confused... I am sending a list (that could have one, but will more than likely have several keys) to this sp to bring back a representation of the data to vfp. I am allowing the programmer to limit everything (Select list, where clause, group by clause, etc) so I might limit network traffic - that's why the select will (may) never be the same.
>
>How could I create the same functionality in one select?