<root>
    <userid>12345</userid>
    <person>
        <fname>John</fname>
        <lname>Dow</lname>
        <note>some notes here...</note>
    </person>
    <person>
        <fname>Jane</fname>
        <lname>Doedet</lname>
        <note>notes goes here...</note>
</root>

DECLARE @xmlDoc VARCHAR(8000)
DECLARE @xmlHandle INT
BEGIN
	SET @xmlDoc = 
	'
<root>
    <userid>12345</userid>
    <person>
        <fname>John</fname>
        <lname>Dow</lname>
        <note>some notes here...</note>
    </person>
    <person>
        <fname>Jane</fname>
        <lname>Doedet</lname>
        <note>notes goes here...</note>
	</person>
</root>

	'

	EXEC sp_xml_preparedocument @xmlHandle OUTPUT, @xmlDoc
Insert Into test_table
	SELECT * FROM OPENXML (@xmlHandle, '/root/person', 2) WITH
		(
			userid	VARCHAR(20) '../userid',
			fname	VARCHAR(50) './fname',
			lname VARCHAR(50) './lname',
			notes VARCHAR(50) './note'
		)

	
	EXEC sp_xml_removedocument @xmlHandle
END