.NET
Michael Rys has a two part article on Moving FOR XML EXPLICIT to the new PATH mode. Very cool stuff coming in YUKON.
References:Blog: http://sqljunkies.com/WebLog/mrys/Part One: http://sqljunkies.com/WebLog/mrys/archive/2004/02/19/1201.aspxPart Two: http://sqljunkies.com/WebLog/mrys/archive/2004/02/19/1208.aspx