Loop thru XML tags with Cursor

Transact-SQL
1

So, here's the XML.. I am relying on order of presence in file.

<?xml version="1.0" ?>
<ROOT>
<Policy>
<PolicyNumber> HO00000001 </PolicyNumber>
<TransactionType> NB </TransactionType>
<AccountingDate> 082018 </AccountingDate>
<PolicyEffectiveDate> 08302018 </PolicyEffectiveDate>
<PolicyExpirationDate> 08302019 </PolicyExpirationDate>
<ChangeDate> 08302018 </ChangeDate>
<Coverages>
<Coverage>
<CoverageCode> PL </CoverageCode>
<Exposure />
<DeductibleType />
<DeductibleAmount />
<Limit1> 110000 </Limit1>
<Limit2 />
<Limit3 />
<Premium> 11.00 </Premium>
</Coverage>
<Coverage>
<CoverageCode> MEDPM </CoverageCode>
<Exposure />
<DeductibleType />
<DeductibleAmount />
<Limit1> 1000 </Limit1>
<Limit2 />
<Limit3 />
<Premium />
</Coverage>
<Coverage>
<CoverageCode> PI </CoverageCode>
<Exposure />
<DeductibleType />
<DeductibleAmount />
<Limit1 />
<Limit2 />
<Limit3 />
<Premium> 11.00 </Premium>
</Coverage>
</Coverages>
</Policy>

<Policy>
<PolicyNumber> HO00000001 </PolicyNumber>
<TransactionType> AM </TransactionType>
<AccountingDate> 093018 </AccountingDate>
<PolicyEffectiveDate> 08302018 </PolicyEffectiveDate>
<PolicyExpirationDate> 08302019 </PolicyExpirationDate>
<ChangeDate> 09302018 </ChangeDate>
<Coverages>
<Coverage>
<CoverageCode> PL </CoverageCode>
<Exposure />
<DeductibleType />
<DeductibleAmount />
<Limit1> 110000 </Limit1>
<Limit2> 120000 </Limit2>
<Limit3> 130000 </Limit3>
<Premium> 31.00 </Premium>
</Coverage>
<Coverage>
<CoverageCode> MEDPM </CoverageCode>
<Exposure />
<DeductibleType />
<DeductibleAmount />
<Limit1> 1000 </Limit1>
<Limit2 />
<Limit3 />
<Premium />
</Coverage>
<Coverage>
<CoverageCode> PI </CoverageCode>
<Exposure />
<DeductibleType />
<DeductibleAmount />
<Limit1 />
<Limit2 />
<Limit3 />
<Premium> 11.00 </Premium>
</Coverage>
</Coverages>
</Policy>

<Policy>
<PolicyNumber> HO00000001 </PolicyNumber>
<TransactionType> AM </TransactionType>
<AccountingDate> 093018 </AccountingDate>
<PolicyEffectiveDate> 08302018 </PolicyEffectiveDate>
<PolicyExpirationDate> 08302019 </PolicyExpirationDate>
<ChangeDate> 09302018 </ChangeDate>
<Coverages>
<Coverage>
<CoverageCode> PL </CoverageCode>
<Exposure />
<DeductibleType />
<DeductibleAmount />
<Limit1> 110001 </Limit1>
<Limit2> 120002 </Limit2>
<Limit3> 130003 </Limit3>
<Premium> 34.00 </Premium>
</Coverage>
<Coverage>
<CoverageCode> MEDPM </CoverageCode>
<Exposure />
<DeductibleType />
<DeductibleAmount />
<Limit1> 1000 </Limit1>
<Limit2 />
<Limit3 />
<Premium />
</Coverage>
<Coverage>
<CoverageCode> PI </CoverageCode>
<Exposure />
<DeductibleType />
<DeductibleAmount />
<Limit1 />
<Limit2 />
<Limit3 />
<Premium> 11.00 </Premium>
</Coverage>
</Coverages>
</Policy>

<Policy>
<PolicyNumber> HO00000001 </PolicyNumber>
<TransactionType> RN </TransactionType>
<AccountingDate> 082019 </AccountingDate>
<PolicyEffectiveDate> 08302019 </PolicyEffectiveDate>
<PolicyExpirationDate> 08302020 </PolicyExpirationDate>
<ChangeDate> 08302018 </ChangeDate>
<Coverages>
<Coverage>
<CoverageCode> PL </CoverageCode>
<Exposure />
<DeductibleType />
<DeductibleAmount />
<Limit1> 110000 </Limit1>
<Limit2> 120000 </Limit2>
<Limit3> 130000 </Limit3>
<Premium> 31.00 </Premium>
</Coverage>
<Coverage>
<CoverageCode> MEDPM </CoverageCode>
<Exposure />
<DeductibleType />
<DeductibleAmount />
<Limit1> 1000 </Limit1>
<Limit2 />
<Limit3 />
<Premium />
</Coverage>
<Coverage>
<CoverageCode> PI </CoverageCode>
<Exposure />
<DeductibleType />
<DeductibleAmount />
<Limit1 />
<Limit2 />
<Limit3 />
<Premium> 11.00 </Premium>
</Coverage>
</Coverages>
</Policy>
</ROOT>

I'm trying to cursor thru the XML, processing one <Policy> segment at a time. As you can see, there can be multiple <Policy> segments for the same <PolicyNumber>. What I'm running into is that when I try to process the <Coverages><Coverage> for a specific <Policy> segment I end up getting all of the <Coverages><Coverage> in the XML. The <PolicyNumber>, <TransactionType>, <AccountingDate>, etc. come thru fine.

Any idea on how I can do this?

Here's my code:

USE CompanyImport
GO

CREATE TABLE XMLwithOpenXML
(
Id INT IDENTITY PRIMARY KEY,
XMLData XML,
LoadedDateTime DATETIME
)

INSERT INTO XMLwithOpenXML(XMLData, LoadedDateTime)
SELECT CONVERT(XML, BulkColumn) AS BulkColumn, GETDATE()

FROM OPENROWSET(BULK '\ASI3\ASI\ASI Projects\Stat Reporting\Documentation\Table Definitions\Stat Reporting Input Layout-TestData_MultipleTrans_OnePolicy.xml', SINGLE_BLOB) AS x;

DECLARE @XML AS XML, @hDoc AS INT, @SQL NVARCHAR (MAX)

SELECT @XML = XMLData FROM XMLwithOpenXML WHERE ID = '1' -- The row to process

-- IDENTITY IDs
DECLARE @PolicyID BIGINT
DECLARE @ProductID BIGINT

--*** BEGIN POLICY PROCESSING ***

-- Policy Columns
DECLARE @CompanyID SMALLINT
DECLARE @PolicyNumber VARCHAR(50)
DECLARE @TransactionType VARCHAR(50)
DECLARE @EffectiveDate VARCHAR(50)
DECLARE @ExpirationDate VARCHAR(50)
DECLARE @ChangeDate VARCHAR(50)
DECLARE @AccountingDate VARCHAR(MAX)
DECLARE @AccountingYear VARCHAR(50)
DECLARE @AccountingMonth VARCHAR(50)

-- Default Company to 1
SET @CompanyID = 1

-- Loop thru XML and process each Policy
DECLARE POLICY_CURSOR CURSOR LOCAL FAST_FORWARD FOR
SELECT s.c.value('(PolicyNumber/text())[1]', 'nvarchar(max)') as PolicyNumber,
s.c.value('(TransactionType/text())[1]', 'nvarchar(max)') as TransactionType,
s.c.value('(PolicyEffectiveDate/text())[1]', 'nvarchar(max)') as EffectiveDate,
s.c.value('(PolicyExpirationDate/text())[1]', 'nvarchar(max)') as ExpirationDate,
s.c.value('(ChangeDate/text())[1]', 'nvarchar(max)') as ChangeDate,
s.c.value('(AccountingDate/text())[1]', 'nvarchar(max)') as AccountingDate
FROM @XML.nodes('ROOT') AS m(c)
OUTER APPLY m.c.nodes('Policy') as s(c)

OPEN POLICY_CURSOR
FETCH NEXT FROM POLICY_CURSOR INTO @PolicyNumber, @TransactionType, @EffectiveDate, @ExpirationDate, @ChangeDate, @AccountingDate
WHILE (@@FETCH_STATUS = 0) BEGIN
BEGIN TRY
SET @POLICYCOUNT = @POLICYCOUNT + 1

	---- Insert Policy Record
	SET @AccountingYear = SUBSTRING(@AccountingDate,3,2)
	SET @AccountingMonth = SUBSTRING(@AccountingDate,1,2)

	PRINT 'Policy = ' + CONVERT (VARCHAR, @PolicyNumber)
	PRINT 'Trans = ' + CONVERT (VARCHAR, @TransactionType)
	PRINT 'Eff = ' + CONVERT (VARCHAR, @EffectiveDate)
	PRINT 'Exp = ' + CONVERT (VARCHAR, @ExpirationDate)
	PRINT 'Chg = ' + CONVERT (VARCHAR, @ChangeDate)
	PRINT 'AcctYr = ' + CONVERT (VARCHAR, @AccountingYear)
	PRINT 'AcctMo = ' + CONVERT (VARCHAR, @AccountingMonth)

	PRINT '**************************************************'


	--*** BEGIN POLICY COVERAGE PROCESSING ***
	-- Coverage Columns
	DECLARE @CoverageCode VARCHAR(50)
	DECLARE @Limit1 VARCHAR(50)
	DECLARE @Limit2 VARCHAR(50)
	DECLARE @Limit3 VARCHAR(50)
	DECLARE @Exposure VARCHAR(50)
	DECLARE @Premium VARCHAR(50)
	DECLARE @ClassCode VARCHAR(50)
	DECLARE @DeductibleType VARCHAR(50)
	DECLARE @DeductibleAmount VARCHAR(50)

	-- Loop thru Policy Level Coverages
	DECLARE POLICY_COVG_CURSOR CURSOR LOCAL FAST_FORWARD FOR
		SELECT s.c.value('(CoverageCode/text())[1]', 'nvarchar(max)') as CoverageCode,
			   s.c.value('(Exposure/text())[1]', 'nvarchar(max)') as Exposure,
			   s.c.value('(DeductibleType/text())[1]', 'nvarchar(max)') as DeductibleType,
			   s.c.value('(DeductibleAmount/text())[1]', 'nvarchar(max)') as DeductibleAmount,
			   s.c.value('(Limit1/text())[1]', 'nvarchar(max)') as Limit1,
			   s.c.value('(Limit2/text())[1]', 'nvarchar(max)') as Limit2,
			   s.c.value('(Limit3/text())[1]', 'nvarchar(max)') as Limit3,
			   s.c.value('(Premium/text())[1]', 'nvarchar(max)') as Premium
		FROM @XML.nodes('ROOT/Policy') AS m(c)
		OUTER APPLY m.c.nodes('Coverages/Coverage') as s(c)

	OPEN POLICY_COVG_CURSOR
	FETCH NEXT FROM POLICY_COVG_CURSOR INTO @CoverageCode, @Exposure, @DeductibleType, @DeductibleAmount, @Limit1, @Limit2, @Limit3, @Premium
	WHILE (@@FETCH_STATUS = 0) BEGIN
		BEGIN TRY
			
			PRINT 'CovgCd = ' + CONVERT (VARCHAR, @CoverageCode)
			PRINT 'Exposure = ' + CONVERT (VARCHAR, @Exposure)
			PRINT 'DedType = ' + CONVERT (VARCHAR, @DeductibleType)
			PRINT 'DedAmt = ' + CONVERT (VARCHAR, @DeductibleAmount)
			PRINT 'L1 = ' + CONVERT (VARCHAR, @Limit1)
			PRINT 'L2 = ' + CONVERT (VARCHAR, @Limit2)
			PRINT 'L3 = ' + CONVERT (VARCHAR, @Limit3)
			PRINT 'Prem = ' + CONVERT (VARCHAR, @Premium)

		END TRY
		BEGIN CATCH
			PRINT error_message()
		END CATCH

		FETCH NEXT FROM POLICY_COVG_CURSOR INTO @CoverageCode, @Exposure, @DeductibleType, @DeductibleAmount, @Limit1, @Limit2, @Limit3, @Premium

		IF @@FETCH_STATUS = 0
			PRINT '**************************************************'
	END

	CLOSE POLICY_COVG_CURSOR
	DEALLOCATE POLICY_COVG_CURSOR

	--*** END POLICY COVERAGE PROCESSING ***


	--*** BEGIN UNIT PROCESSING ***
	-- Unit Columns
	DECLARE @PolicyForm VARCHAR(50)
	DECLARE @LocationState VARCHAR(50)
	DECLARE @LocationZipCode VARCHAR(50)
	DECLARE @LocationZipCodePlus4 VARCHAR(50)
	DECLARE @LocationCountyCode VARCHAR(50)
	DECLARE @TerritoryCode VARCHAR(50)
	DECLARE @FireProtectionCode VARCHAR(50)
	DECLARE @ConstructionCode VARCHAR(50)
	DECLARE @ConstructionYear VARCHAR(50)
	DECLARE @OccupancyCode VARCHAR(50)
	DECLARE @ResidencyCode VARCHAR(50)
	DECLARE @UnitDeductibleType VARCHAR(50)
	DECLARE @UnitDeductibleAmount VARCHAR(50)
	DECLARE @WindHailDeductibleAmount VARCHAR(50)
	DECLARE @TheftDeductibleAmount VARCHAR(50)

	-- Loop thru Policy Units
	DECLARE UNIT_CURSOR CURSOR LOCAL FAST_FORWARD FOR
		SELECT s.c.value('(PolicyForm/text())[1]', 'nvarchar(max)') as PolicyForm,
			   s.c.value('(LocationState/text())[1]', 'nvarchar(max)') as LocationState,
			   s.c.value('(LocationZipCode/text())[1]', 'nvarchar(max)') as LocationZipCode,
			   s.c.value('(LocationZipCodePlus4/text())[1]', 'nvarchar(max)') as LocationZipCodePlus4,
			   s.c.value('(LocationCountyCode/text())[1]', 'nvarchar(max)') as LocationCountyCode,
			   s.c.value('(TerritoryCode/text())[1]', 'nvarchar(max)') as TerritoryCode,
			   s.c.value('(FireProtectionCode/text())[1]', 'nvarchar(max)') as FireProtectionCode,
			   s.c.value('(ConstructionCode/text())[1]', 'nvarchar(max)') as ConstructionCode,
			   s.c.value('(ConstructionYear/text())[1]', 'nvarchar(max)') as ConstructionYear,
			   s.c.value('(OccupancyCode/text())[1]', 'nvarchar(max)') as OccupancyCode,
			   s.c.value('(ResidencyCode/text())[1]', 'nvarchar(max)') as ResidencyCode,
			   s.c.value('(DeductibleType/text())[1]', 'nvarchar(max)') as UnitDeductibleType,
			   s.c.value('(DeductibleAmount/text())[1]', 'nvarchar(max)') as UnitDeductibleAmount,
			   s.c.value('(WindHailDeductibleAmount/text())[1]', 'nvarchar(max)') as WindHailDeductibleAmount,
			   s.c.value('(TheftDeductibleAmount/text())[1]', 'nvarchar(max)') as TheftDeductibleAmount
		FROM @XML.nodes('Policy') AS m(c)
		CROSS APPLY m.c.nodes('Homeowners') as s(c)

	OPEN UNIT_CURSOR
	FETCH NEXT FROM UNIT_CURSOR INTO @PolicyForm, @LocationState, @LocationZipCode, @LocationZipCodePlus4, @LocationCountyCode, @TerritoryCode,
											@FireProtectionCode, @ConstructionCode, @ConstructionYear, @OccupancyCode, @ResidencyCode, @UnitDeductibleType,
											@UnitDeductibleAmount, @WindHailDeductibleAmount, @TheftDeductibleAmount
	WHILE (@@FETCH_STATUS = 0) BEGIN
		BEGIN TRY

			PRINT '++++++++++++++++++++++++++++++++++++++++++++++++++'

			PRINT 'Form = ' + CONVERT (VARCHAR, @PolicyForm)
			PRINT 'St = ' + CONVERT (VARCHAR, @LocationState)
			PRINT 'Zip = ' + CONVERT (VARCHAR, @LocationZipCode)
			PRINT 'Zip4 = ' + CONVERT (VARCHAR, @LocationZipCodePlus4)
			PRINT 'Cnty = ' + CONVERT (VARCHAR, @LocationCountyCode)
			PRINT 'Terr = ' + CONVERT (VARCHAR, @TerritoryCode)
			PRINT 'FPC = ' + CONVERT (VARCHAR, @FireProtectionCode)
			PRINT 'ConstCd = ' + CONVERT (VARCHAR, @ConstructionCode)
			PRINT 'ConstYr = ' + CONVERT (VARCHAR, @ConstructionYear)
			PRINT 'Occ = ' + CONVERT (VARCHAR, @OccupancyCode)
			PRINT 'Res = ' + CONVERT (VARCHAR, @ResidencyCode)
			PRINT 'DedType = ' + CONVERT (VARCHAR, @UnitDeductibleType)
			PRINT 'DedAmt = ' + CONVERT (VARCHAR, @UnitDeductibleAmount)
			PRINT 'WHDed = ' + CONVERT (VARCHAR, @WindHailDeductibleAmount)
			PRINT 'TDed = ' + CONVERT (VARCHAR, @TheftDeductibleAmount)


			--*** BEGIN UNIT COVERAGE PROCESSING ***
			-- Coverage Columns: Already declared above in Policy Level Coverages

			-- Loop thru Unit Level Coverages
			DECLARE UNIT_COVG_CURSOR CURSOR LOCAL FAST_FORWARD FOR
				SELECT s.c.value('(CoverageCode/text())[1]', 'nvarchar(max)') as CoverageCode,
					   s.c.value('(Exposure/text())[1]', 'nvarchar(max)') as Exposure,
					   s.c.value('(DeductibleType/text())[1]', 'nvarchar(max)') as DeductibleType,
					   s.c.value('(DeductibleAmount/text())[1]', 'nvarchar(max)') as DeductibleAmount,
					   s.c.value('(Limit1/text())[1]', 'nvarchar(max)') as Limit1,
					   s.c.value('(Limit2/text())[1]', 'nvarchar(max)') as Limit2,
					   s.c.value('(Limit3/text())[1]', 'nvarchar(max)') as Limit3,
					   s.c.value('(Premium/text())[1]', 'nvarchar(max)') as Premium
				FROM @XML.nodes('Policy') AS m(c)
				CROSS APPLY m.c.nodes('Homeowners/Coverages/Coverage') as s(c)

			OPEN UNIT_COVG_CURSOR
			FETCH NEXT FROM UNIT_COVG_CURSOR INTO @CoverageCode, @Exposure, @DeductibleType, @DeductibleAmount, @Limit1, @Limit2, @Limit3, @Premium
			WHILE (@@FETCH_STATUS = 0) BEGIN
				BEGIN TRY
			
					PRINT '++++++++++++++++++++++++++++++++++++++++++++++++++'

					PRINT 'CovgCd = ' + CONVERT (VARCHAR, @CoverageCode)
					PRINT 'Exposure = ' + CONVERT (VARCHAR, @Exposure)
					PRINT 'DedType = ' + CONVERT (VARCHAR, @DeductibleType)
					PRINT 'DedAmt = ' + CONVERT (VARCHAR, @DeductibleAmount)
					PRINT 'L1 = ' + CONVERT (VARCHAR, @Limit1)
					PRINT 'L2 = ' + CONVERT (VARCHAR, @Limit2)
					PRINT 'L3 = ' + CONVERT (VARCHAR, @Limit3)
					PRINT 'Prem = ' + CONVERT (VARCHAR, @Premium)

				END TRY
				BEGIN CATCH
					PRINT error_message()
				END CATCH

				FETCH NEXT FROM UNIT_COVG_CURSOR INTO @CoverageCode, @Exposure, @DeductibleType, @DeductibleAmount, @Limit1, @Limit2, @Limit3, @Premium

				IF @@FETCH_STATUS = 0
					PRINT '++++++++++++++++++++++++++++++++++++++++++++++++++'
			END

			CLOSE UNIT_COVG_CURSOR
			DEALLOCATE UNIT_COVG_CURSOR

			--*** END UNIT COVERAGE PROCESSING ***

		END TRY
		BEGIN CATCH
			PRINT error_message()
		END CATCH

		FETCH NEXT FROM UNIT_CURSOR INTO @PolicyForm, @LocationState, @LocationZipCode, @LocationZipCodePlus4, @LocationCountyCode, @TerritoryCode,
											@FireProtectionCode, @ConstructionCode, @ConstructionYear, @OccupancyCode, @ResidencyCode, @UnitDeductibleType,
											@UnitDeductibleAmount, @WindHailDeductibleAmount, @TheftDeductibleAmount

		IF @@FETCH_STATUS = 0
			PRINT '++++++++++++++++++++++++++++++++++++++++++++++++++'
	END

	CLOSE UNIT_CURSOR
	DEALLOCATE UNIT_CURSOR

	--*** END UNIT PROCESSING ***

END TRY
BEGIN CATCH
	PRINT error_message()
END CATCH

FETCH NEXT FROM POLICY_CURSOR INTO @PolicyNumber, @TransactionType, @EffectiveDate, @ExpirationDate, @ChangeDate, @AccountingDate

IF @@FETCH_STATUS = 0
	PRINT '--------------------------------------------------'

END

CLOSE POLICY_CURSOR
DEALLOCATE POLICY_CURSOR

--*** END POLICY PROCESSING ***
GO

DROP TABLE XMLwithOpenXML

PRINT '^^^^^^^^^^^ DONE ^^^^^^^^^^^'

Here's the output:

(1 row(s) affected)
Policy = HO00000001
Trans = NB
Eff = 08302018
Exp = 08302019
Chg = 08302018
AcctYr = 20
AcctMo = 08

CovgCd = PL

L1 = 110000

Prem = 11.00

CovgCd = MEDPM

L1 = 1000

CovgCd = PI

Prem = 11.00

CovgCd = PL

L1 = 110000
L2 = 120000
L3 = 130000
Prem = 31.00

CovgCd = MEDPM

L1 = 1000

CovgCd = PI

Prem = 11.00

CovgCd = PL

L1 = 110001
L2 = 120002
L3 = 130003
Prem = 34.00

CovgCd = MEDPM

L1 = 1000

CovgCd = PI

Prem = 11.00

CovgCd = PL

L1 = 110000
L2 = 120000
L3 = 130000
Prem = 31.00

CovgCd = MEDPM

L1 = 1000

CovgCd = PI

Prem = 11.00
POLICY COVG COUNT: 12

Policy = HO00000001
Trans = AM
Eff = 08302018
Exp = 08302019
Chg = 09302018
AcctYr = 30
AcctMo = 09

CovgCd = PL

L1 = 110000

Prem = 11.00

CovgCd = MEDPM

L1 = 1000

CovgCd = PI

Prem = 11.00

CovgCd = PL

L1 = 110000
L2 = 120000
L3 = 130000
Prem = 31.00

CovgCd = MEDPM

L1 = 1000

CovgCd = PI

Prem = 11.00

CovgCd = PL

L1 = 110001
L2 = 120002
L3 = 130003
Prem = 34.00

CovgCd = MEDPM

L1 = 1000

CovgCd = PI

Prem = 11.00

CovgCd = PL

L1 = 110000
L2 = 120000
L3 = 130000
Prem = 31.00

CovgCd = MEDPM

L1 = 1000

CovgCd = PI

Prem = 11.00
POLICY COVG COUNT: 24

Policy = HO00000001
Trans = AM
Eff = 08302018
Exp = 08302019
Chg = 09302018
AcctYr = 30
AcctMo = 09

CovgCd = PL

L1 = 110000

Prem = 11.00

CovgCd = MEDPM

L1 = 1000

CovgCd = PI

Prem = 11.00

CovgCd = PL

L1 = 110000
L2 = 120000
L3 = 130000
Prem = 31.00

CovgCd = MEDPM

L1 = 1000

CovgCd = PI

Prem = 11.00

CovgCd = PL

L1 = 110001
L2 = 120002
L3 = 130003
Prem = 34.00

CovgCd = MEDPM

L1 = 1000

CovgCd = PI

Prem = 11.00

CovgCd = PL

L1 = 110000
L2 = 120000
L3 = 130000
Prem = 31.00

CovgCd = MEDPM

L1 = 1000

CovgCd = PI

Prem = 11.00
POLICY COVG COUNT: 36

Policy = HO00000001
Trans = RN
Eff = 08302019
Exp = 08302020
Chg = 08302018
AcctYr = 20
AcctMo = 08

CovgCd = PL

L1 = 110000

Prem = 11.00

CovgCd = MEDPM

L1 = 1000

CovgCd = PI

Prem = 11.00

CovgCd = PL

L1 = 110000
L2 = 120000
L3 = 130000
Prem = 31.00

CovgCd = MEDPM

L1 = 1000

CovgCd = PI

Prem = 11.00

CovgCd = PL

L1 = 110001
L2 = 120002
L3 = 130003
Prem = 34.00

CovgCd = MEDPM

L1 = 1000

CovgCd = PI

Prem = 11.00

CovgCd = PL

L1 = 110000
L2 = 120000
L3 = 130000
Prem = 31.00

CovgCd = MEDPM

L1 = 1000

CovgCd = PI

Prem = 11.00
^^^^^^^^^^^ DONE ^^^^^^^^^^^

Thanks.
Dave.

2

looks like your xml did not post properly. can you retry or post it to a forum that accepts xml and send us link to that post

3

Trying to get the XML to come thru. Please bear with me.... Where can I post it?

4

try wrapping with <code></code>

<Subcategories> <Subcategory ProductSubcategoryID = "18" Name="Bib-Shorts"> <Products> <Product> <ProductID Type="1">855</ProductID> <ProductID Type="2">676</ProductID> <Name>Men's Bib-Short, s</Name> <ProductNumber>SB-M891-S</ProductNumber> <ListPrice>89.9900</ListPrice> <ModifiedDate>2008-03-11T10:01:36.827</ModifiedDate> </Product> </Products> </Subcategory> </Subcategories>
6

XML is out here now. Thanks.

8

hard to work with an image.

try wrapping the xml within <code></code>

9

XML is out there now. Thanks.