Chances are good that a suitable set-based approach exists, however in order to help we will need a few things:
1. Sample DDL in the form of CREATE TABLE statements
2. Sample data in the form of INSERT INTO statements
3. Expected results based on the sample data
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato