I have two stored procedured the second depends the first.
I call the first with a set of parameters and for each record returned call another stored procedure
with paramter values obtained from the result of running the first.
Asume knowing a phone number, I call the first sp with the phonenumber as a paramter, it returns records
containinig first and last names. Then for each record returned by the first I call the second stored
procedure and I pass the last name the second sp returns the name of a city correcponding with the last
name passed to it.
The result should contain for each record
FirstName LastName City