>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?
We already have it in VFP and C#.Net. My intention is that to compare the performance and at the same time, it will be useful for any platform - .NET (Web or Win), Java, etc. long term. The .NET version is done in C#.Net which is already a separate layer so we can make use of it even in Web app. But I am trying to do some experimentations in SPs, and if it is found faster then we'll go with SPs. Thanks.
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."
