I found that out. I took out the Additional Fields and it worked fine.

Thanks for all your help.

I thought of that but I am still returning null values.

How can I get this section to parse out:

[BusinessEntityAddresses xmlns="http://www.thatchertech.com/Prowess/Services"]

[BusinessEntityAddress]

[AdditionalFields /]

[AddressLine1]9246 FOLIAGE LANE[/AddressLine1]

[City]Munster[/City]

[PostalCode]46321[/PostalCode]

[State StateCode="IN"]

[StateGuid IsNull="false" DecimalValue="23567725519222135717227012983" /]

[/State]

[Country CountryCode="United States"]

[CountryGuid IsNull="false" DecimalValue="63176971073076024173865642249" /]

[/Country]

[NlsCounty]LAKE

[IsWithinCityLimits FieldName="IsWithinCityLimits"]

true</FieldValue]

[/IsWithinCityLimits]

[/BusinessEntityAddress]

[/BusinessEntityAddresses]

I am trying to use the...

Can you explain what is going on here?

select r.value('(../../../n1:BusinessIdentifier/n1:BusinessGuid)[1]/@DecimalValue','varchar(30)') as DecimalValue,...

It returning a empty recordset.

Would each namespace equate itself to a table?

See if this helps:

- [ArrayOfExportBusinessEntity xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"]

- [ExportBusinessEntity]

[ExternalReference xmlns="http://www.thatchertech.com/Prowess/Services"]247378[/ExternalReference]

[ChangeType xmlns="http://www.thatchertech.com/Prowess/Services"]5[/ChangeType]

- [Salutation xmlns="http://www.thatchertech.com/Prowess/Services" CodeID="MS"]

[CodeGuid IsNull="false" DecimalValue="4394317858950256120563031138" /]

[/Salutation]

[FirstName xmlns="http://www.thatchertech.com/Prowess/Services"]April[/FirstName]...

Thanks for the tip, but the end result will be the data within the XML document will be stored into SQL tables. What I need is to take the schema...

That was the ticket. Thanks. I did not get past the ALTER AUTHORIZATION in BOL so I probably should have dug deeper. Thanks again.

Can you explain that last statement? An Example might help.

That is what I figured out.

IF (@Status = 'Active')

SET @SQLStr = 'SELECT * FROM #DLFiltered WHERE Active = 1 '

SET @SQLStr = @SQLStr + ' AND CurrentLevelXID >= ' +...

Tam trying this:

IF (@Status = 'Active')

SET @SQLStr = 'SELECT * FROM #DLFiltered WHERE Active = 1'+ CHAR(13);

SET @SQLStr = @SQLStr + ' AND CurrentLevelXID >= ' + @AchieveLevel + '...

How would I do that? Can you show me an example?

Do you have an example of one?

That's the ticket. Thanks.

Thanks for the tip, I took out the temp table and it runs like a champ.