Re: XQuery Error - Trying to parse XML column - 08-31-2010 , 07:07 AM
Mitchell_Collen via SQLMonster.com wrote:
'/blocked-process-report'. Your argument ends with '/', that is not a
syntactically correct path expression. You might want e.g.
SELECT X.x.value('@waitresource', 'nvarchar(20)')
TextData.nodes('/blocked-process-report/blocked-process/process') AS X(x)
to use a path that is more likely to give a meaningful result with the
XML sample you show below.
Martin Honnen --- MVP Data Platform Development
Re: XQuery Error - Trying to parse XML column - 08-31-2010 , 08:08 AM
Martin, you are a genius! Thanks! It did exactly what I need, now I can
expand on that in my query!
Thanks so much!
Message posted via SQLMonster.com