OUCH! SQL Server is not good at record processing. Unless you're doing something very simple inside the loop, my guess is it will be faster to pull the data into VFP, process it there, then send it back.
>Hey Guys!
>
>Using SQL2005, I want to create a Stored Procedure that gets set of data, scan it ala Scan...Endscan in VFP, then do some data manipulations inside. Is there any?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer