>>>Hi Jess!
>>>
>>>I don't know how it is done inside SQL Server but inside your C# code you would do it with a FOREACH.
>>>
>>>example:
>>>
>>>foreach (DataRow dr in dataset.Tables[0])
>>>{
>>> ...
>>>}
>>>
>>>
>>>>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?
>>
>>Robert,
>>
>>Thanks! But that's what I do now. I am thinking of its equivalent SQLServer SP syntax and see if it has an advantage when it comes to speed.
>
>You could use CURSOR, but keep in mind that cursors are performance killers. Check DECLARE CURSOR and FETCH commands in BOL
>There is another way but it depends of what you want to do and how your Data is organized.
I already have a separate data layer using MM.Net business objects but I want to try an SP execution for comparison. But if you're saying that the SP method kills performance, it only defeats the purpose.
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."