have a look at cross apply.

You can call a function for each row of a resultset and return a resultset.

Not sure that's what you want to do but sounds something like it.