Thursday, March 06, 2008

Hey everyone... My comment notifications are broken, so I'm sorry if you posted a comment and I didn't reply.

Oh, and Joe, no I'm not planning on going to any VS Live events.  Are you?  If so, which ones?  Maybe I'll change my mind.

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.