OK, I finally figured out what all the hubbub is about with CROSS APPLY and XML!
It lets you "cross" a parent node with its children, and I guess in a relatively efficient manner.
I suppose lots of people already understood this, but my XML book hasn't arrived from B&N yet, and BOL hasn't been the best tutorial on this stuff. Anyway, right now I'm one fellow feeling smart.
A few more tricks like this, and I'll take off my XML newbie hat.
ps - as soon as I can figure out this posting interface I'll really feel smart!
The CROSS APPLY join is one of the features that was added in SQL Server 2005. Yes, I find it useful for a number of XML queries. This feature also provides additional usefulness for table valued functions -- especially inline functions.
( OT, I think )
No comments:
Post a Comment