I had to do a deep traversal of a simple parent/child hierarchy in SQL today. I found an old article that explained a very easy method. I made a few tweaks, and since my base table is so small, I ended up creating the hierarchy as a temp table in my sproc. If it was larger, I'd create the table ahead of time.
posted on Thursday, March 06, 2008 1:18 PM