Is it possible to run a stored procedure for each record against a resultset?

For example, 

```
Select * from Customers

```

for each record in the results above execute my stored procedure.

And also (not really important if not possible), have all this inside a main stored procedure?