With one change to Adi SQL, I have the solution

SELECT X.MPL.value('(../../PriceListId)[1]', 'nvarchar(4)') As PriceListID,

X.MPL.value('(../../ThisDocumentGenerationTime)[1]', 'nvarchar(20)') As DocDateTime,

X.MPL.value('(../FamilyName)[1]', 'nvarchar(50)') As PGroup,

X.MPL.value('(FamilyName)[1]', 'nvarchar(50)') As PSubGroup,

Y.MPL.value('(.)[1]', 'nvarchar(50)') As ProductNumber

FROM (

SELECT CAST(x AS...

Adi Cohn-120898

select NewTbl.XMLCol.value('(../../PriceListId)[1]', 'int') as PriceListID,

NewTbl.XMLCol.value('(../../GenerationTime)[1]', 'char(8)'),

NewTbl.XMLCol.value('(../FamilyName)[1]','varchar(50)') as MajorFamilyName,

...

I can return five columns with PriceListId, DocDateTime as nvarchar text and the remaining 3 columns include XML for the /MajorFamily/FamilyName, /MinorFamily/FamilyName, and /MinorFamily/ProductNumber container elements, which need to be...