The XML part... the necessary calls to the sp's for the XML preparation and removal?
We are going to have several sp's representing tables in the sql database. The calls I am writing are part of a custom data access class for the tables.
Wayne
>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?
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown