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 ?