I'm new here. If this isn't the right group for this question, please let me know.

I'm working with sql server 2000 (and learning C++) and I wanted to know if it is possible to create an extended stored procedure that would convert an adjacency list model to a nested set model on-the-fly. I have done this in a regular stored procedure, but was curious if an extended stored procedure might be faster. I haven't seen any C++ examples though ..

Any thoughts or suggestions would be appreciated.