>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