doing the
subselects - even though they return 5-10 records each. Basically this is a
parent record with up to two children recordsets. I think there may be a
faster way to do this, but am not quite sure what sql tools are at my
disposal. Anyone have an idea of how to approach this???
Jon Wahl
I would go for the parameterized solution here - fully flexible routines are
a very good thing. Plus it sounds as if your tables will be more
normalized - i.e. you won't be including meta-data in your data tables (if
I'm interpreting what you're saying correctly).
Good luck,
Jon
> -Origina