>>>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.