You can use SQL Server cursor to lop through any subset of data. The question is, do you have to? SQL Server is much better with set oriented peocessing. The record based processin is much less effective.
>Hi All, I have a SP which I would like to "call" once for every record in a table - e.g. in VFP I would do something like
>
>
>use mytable
>
>scan
> EXEC MySP mytable.field1
>endscan
>
>
>
>I know it's frowned upon sequentially scanning a table in SQL server but I don't know of any other way - is this doable ?
--sb--