Jacob, please find sample XML & its parsing function:

declare @XMLdata XML

SET @XMLdata =

'<XmlStart xmlns="http://abc.com" xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns:a="http://hd.com">

<data>

<a:Col1>

<a:col1Data>

<a:data1>5</a:data1>

<a:data2>

<a:data3>Hello</a:data3>

</a:data2>

</a:col1Data>

</a:Col1>

</data>

</XmlStart>'

CREATE FUNCTION hdFunction ( @XMLdata XML )

RETURNS @Datatable TABLE

(

Col1 SMALLINT

, Col2 NVARCHAR(12)

)

AS BEGIN

WITH XMLNAMESPACES ( DEFAULT 'http://abc.com', 'http://hd.com' AS a,

'http://www.w3.org/2001/XMLSchema-instance' AS i )

INSERT INTO @Datatable

SELECT T.C.value('a:data1[1]', 'smallint') AS Column1

, T.C.value('(a:data2/a:data3)[1]', 'nvarchar(12)') AS Column2

FROM @XMLdata.nodes('/XmlStart/Data/a:col1/a:col1Data') T ( C )

RETURN

END