Hi,
I am using XML functions in T-SQL to parse a series of XML document. The trouble is that these messages can have one of a range of namespaces and there is no way of knowing ahead of time which namespace is being used as the default. Hence I have some
code that looks like this:
DECLARE @vMessageType NVARCHAR(128);
SET @vMessageType = @pMessage.value('declare default element namespace "http://tempuri.net/namespace1";
local-name((/Messages/*[1])[1])','nvarchar(128)');
IF @vMessageType = ''
SET @vMessageType = @pMessage.value('declare default element namespace "http://tempuri.net/namespaec2"; local-name((/Messages/*[1])[1])','nvarchar(128)');
IF @vMessageType = ''
SET @vMessageType = @pMessage.value('declare default element namespace "http://tempuri.n
View Complete Post