Thanks Grant. By Dynamic TSQL, do you mean the approach I described of pulling the value of the parameters from a table updated just before the query is fired? Or...

Sorry ChrisM. I really didn't give you much to work with. Table 1 has Parent data, and a UDF returns subordinates to the ParentID passed to it. The UDF returns...

Sorry! I should have posted this to the 2K5 section!

Bingo! Got it. Thanks

Hi there.

Curious why the design may be bad. I have the items in one table along with their attributes, and the way they interact with one another (hierarchies) in another....

Thanks for the help. To be clear, you're suggesting two inserts. One to load the parent ids and a second to load the child IDs? I think that's where you're...