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

Could your sp be defined as an fn? You could directly call fn and also check cross apply.
Cetin