ChiragNS (3/12/2009)
Why 4 points for this question? I mean u can run this thing in SSMS and get the answer.
Maybe I should have done that - I might have been four points better off. But I wouldn't have had the mental excercise of trying to recall how xml works in sql server.
Tom