Unanswered: Is ROOT('name') compliant with SQL 2000?
I'm not sure when our servers will be updated to 2008, but I'm using a 2008 book and Management Studio 2008 with the database. Unfortunately that means I run into instances where I find a really easy solution that's not compatible. If I can't use the ROOT statement, is there any other way I can wrap a root around the FOR XML AUTO output? This is a stored procedure btw