>>Hi, Jess,
>>
>>Can you be a little more specific as to what kind of data manipulation you want/need to do with your result set from the stored proc?
>
>First, the data manipulation will done inside the Stored Procedure. What I mean is, inside the Stored Procedure, I can do "Update From " or "Delete From" or "Insert Into...". These statements will be executed inside the loop if there is any.
Jess,
Can you write a simple VFP code that you want to translate it to T-SQL?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.