Scott,

Its nice that Google has the concept of hierarchical structure, but in practice I don't think it works for other means of generating KML either.

Thanks for the note, I'll update...

Thanks for the feedback and corrections.

I appreciate you taking the time to dig into this with such energy.

I haven't had the pleasure to work with SQLServer 2008 yet, but look...

Thanks for the feedback.

My goal was to provide one way to do generate KML, but over time I might find a more elegant way of exploiting the FOR XML clause....