DECLARE	@Parameter XML = N'<Statement type="MLN">
<BadgeCode>00</BadgeCode>
<StatementPeriodFromDate>20110101</StatementPeriodFromDate>
<StatementPeriodToDate>20110131</StatementPeriodToDate>
<NominatedAdviserGroup>Blank Bank</NominatedAdviserGroup>
<AccountName>MR J SMITH & MRS J SMITH</AccountName>
<AddressLine1>1703 Evergreen Terrace</AddressLine1>
<Location>Springfield</Location>
<PostCode>E23300</PostCode>
<FacilityNumber>Z772957</FacilityNumber>
</Statement>'

/*
INSERT	dbo.Table1
	(
		StatementType,
		BadgeCode,
		StatementPeriodFromDate,
		StatementPeriodToDate,
		NominatedAdviserGroup,
		AccountName,
		AddressLine1,
		Location,
		PostCode,
		FacilityNumber
)
*/
SELECT	n.value('@type', 'VARCHAR(3)') AS StatementType,
	n.value('BadgeCode[1]', 'VARCHAR(2)') AS BadgeCode,
	n.value('StatementPeriodFromDate[1]', 'DATE') AS StatementPeriodFromDate,
	n.value('StatementPeriodToDate[1]', 'DATE') AS StatementPeriodToDate,
	n.value('NominatedAdviserGroup[1]', 'VARCHAR(20)') AS NominatedAdviserGroup,
	n.value('AccountName[1]', 'VARCHAR(100)') AS AccountName,
	n.value('AddressLine1[1]', 'VARCHAR(100)') AS AddressLine1,
	n.value('Location[1]', 'VARCHAR(40)') AS Location,
	n.value('PostCode[1]', 'VARCHAR(8)') AS PostCode,
	n.value('FacilityNumber[1]', 'VARCHAR(10)') AS FacilityNumber
FROM	@Parameter.nodes('/Statement') AS p(n)