Here is the query

select -- DebitNote
1 as Tag,
null as Parent,
null as [DebitNote!1],
null as [DebitNoteDocumentDetails!2],
null as [DebitNoteDocumentDate!3],
null as [DebitNoteDocumentNumber!4],
null as [DocumentStatus!5],
null as [InvoiceReference!6],
null as [InvoiceDocumentNumber!7],
null as [OrderReference!8], -- col 10
null as [PurchaseOrderNumber!9],
null as [Buyer!10],
null as [BuyerGLN!11],
null as [Address!12],
null as [BuildingIdentifier!13],
null as [PostCode!14],
null as [Seller!15],
null as [SellerGLN!16],
null as [Address!17],
null as [BuildingIdentifier!18], -- col 20
null as [PostCode!19],
null as [ShipTo!20],
null as [ShipToGLN!21],
null as [TaxPointDateTime!22],
null as [DebitItem!23],
null as [DebitItem!23!ChangeReasonCoded],
null as [LineItemNumber!24],
null as [ItemIdentifier!25],
null as [GTIN!26],
null as [InvoiceQuantity!27], -- col 30
null as [DebitQuantity!28],
null as [UnitPrice!29],
null as [LineItemPrice!30],
null as [LineItemDiscount!31],
null as [DiscountValue!32],
null as [DiscountRate!33],
null as [VATDetails!34],
null as [TaxCategory!35],
null as [TaxRate!36],
null as [CreditLineIndicator!37], -- col 40
null as [DebitTotals!38],
null as [DocumentDiscountRate!39],
null as [SettlementDiscountRate!40],
null as [VATRateTotals!41],
null as [VATDetails!42],
null as [TaxCategory!43],
null as [TaxRate!44],
null as [DiscountedLineTotals!45],
null as [DocumentDiscountValue!46],
null as [SettlementDiscountValue!47], -- col 50
null as [TaxableAmount!48],
null as [VATPayable!49],
null as [SettlementSubTotal!50],
null as [DebitNoteSubTotal!51],
null as [VATTotal!52],
null as [SettlementDebitTotal!53],
null as [TotalPayable!54] -- col 57
union select -- DebitNoteDocumentDetails
2,
1,
null, -- DebitNote
null, -- DebitNoteDocumentDetails
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null
union select -- DebitNoteDocumentDate
3,
2,
null, null,
DebitNoteDocumentDate,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null
from DebitNotes_XmlView(1)
union select -- DebitNoteDocumentNumber
4,
2,
null, null, null,
DebitNoteDocumentNumber,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null
from DebitNotes_XmlView(1)
union select -- DocumentStatus
5,
2,
null, null, null, null,
DocumentStatus,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null
from DebitNotes_XmlView(1)
union select -- InvoiceReference
6,
1,
null, null, null, null, null,
null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null
union select -- InvoiceDocumentNumber
7,
6,
null, null, null, null, null, null,
InvoiceDocumentNumber,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null
from DebitNotes_XmlView(1)
union select -- OrderReference
8,
1,
null, null, null, null, null, null, null,
null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null
union select -- PurchaseOrderNumber
9,
8,
null, null, null, null, null, null, null, null,
PurchaseOrderNumber,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null
from DebitNotes_XmlView(1)
union select -- Buyer
10,
1,
null, null, null, null, null, null, null, null, null,
null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null
union select -- BuyerGLN
11,
10,
null, null, null, null, null, null, null, null, null, null,
BuyerGLN,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null
from DebitNotes_XmlView(1)
union select -- Address
12,
10,
null, null, null, null, null, null, null, null, null, null, null,
null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null
union select -- BuyerBuildingIdentifier
13,
12,
null, null, null, null, null, null, null, null, null, null, null, null,
BuyerBuildingIdentifier,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null
from DebitNotes_XmlView(1)
union select -- BuyerPostCode
14,
12,
null, null, null, null, null, null, null, null, null, null, null, null,
null,
BuyerPostCode,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null
from DebitNotes_XmlView(1)
union select -- Seller
15,
1,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null,
null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null
union select -- SellerGLN
16,
15,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null,
SellerGLN,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null
from DebitNotes_XmlView(1)
union select -- Address
17,
15,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null,
null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null
union select -- SellerBuildingIdentifier
18,
17,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null,
SellerBuildingIdentifier,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null
from DebitNotes_XmlView(1)
union select -- SellerPostCode
19,
17,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null,
SellerPostCode,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null
from DebitNotes_XmlView(1)
union select -- ShipTo
20,
1,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null,
null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null
union select -- ShipToGLN
21,
20,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null,
ShipToGLN,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null, null
from DebitNotes_XmlView(1)
union select -- TaxPointDateTime
22,
1,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
TaxPointDateTime,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null
from DebitNotes_XmlView(1)
union select -- DebitItem
23,
1,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null,
null, '5',
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null
union select -- LineItemNumber
24,
23,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null,
LineItemNumber,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null
from DebitNotes_XmlView(1)
union select -- ItemIdentifier
25,
23,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null,
null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null
union select -- GTIN
26,
25,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null,
GTIN,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null
from DebitNotes_XmlView(1)
union select -- InvoiceQuantity
27,
23,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null,
InvoiceQuantity,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null
from DebitNotes_XmlView(1)
union select -- DebitQuantity
28,
23,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null,
DebitQuantity,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null
from DebitNotes_XmlView(1)
union select -- UnitPrice
29,
23,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null,
UnitPrice,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null
from DebitNotes_XmlView(1)
union select -- LineItemPrice
30,
23,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
LineItemPrice,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null
from DebitNotes_XmlView(1)
union select -- LineItemDiscount
31,
23,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null,
null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null
union select -- DiscountValue
32,
31,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null,
DiscountValue,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null
from DebitNotes_XmlView(1)
union select -- DiscountRate
33,
31,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
DiscountRate,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null
from DebitNotes_XmlView(1)
union select -- VATDetails
34,
23,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null,
null,
null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null
union select -- ItemTaxCategory
35,
34,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null,
ItemTaxCategory,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null
from DebitNotes_XmlView(1)
union select -- ItemTaxRate
36,
34,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null,
ItemTaxRate,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null
from DebitNotes_XmlView(1)
union select -- CreditLineIndicator
37,
23,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null,
CreditLineIndicator,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null
from DebitNotes_XmlView(1)
union select -- DebitTotals
38,
1,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null,
null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null
union select -- DocumentDiscountRate
39,
38,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null,
DocumentDiscountRate,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null
from DebitNotes_XmlView(1)
union select -- SettlementDiscountRate
40,
38,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null,
SettlementDiscountRate,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null
from DebitNotes_XmlView(1)
union select -- VATRateTotals
41,
38,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null,
null,
null,
null, null, null, null, null, null, null, null, null, null, null, null, null
union select -- VATDetails
42,
41,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null,
null, null,
null,
null, null, null, null, null, null, null, null, null, null, null, null
union select -- TotalsTaxCategory
43,
42,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null,
null, null, null,
TotalsTaxCategory,
null, null, null, null, null, null, null, null, null, null, null
from DebitNotes_XmlView(1)
union select -- TotalsTaxRate
44,
42,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null,
null, null, null, null,
TotalsTaxRate,
null, null, null, null, null, null, null, null, null, null
from DebitNotes_XmlView(1)
union select -- DiscountedLineTotals
45,
41,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null,
null, null, null, null, null,
DiscountedLineTotals,
null, null, null, null, null, null, null, null, null
from DebitNotes_XmlView(1)
union select -- DocumentDiscountValue
46,
41,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null,
null, null, null, null, null, null,
DocumentDiscountValue,
null, null, null, null, null, null, null, null
from DebitNotes_XmlView(1)
union select -- SettlementDiscountValue
47,
41,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null,
null, null, null, null, null, null, null,
SettlementDiscountValue,
null, null, null, null, null, null, null
from DebitNotes_XmlView(1)
union select -- TaxableAmount
48,
41,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null,
TaxableAmount,
null, null, null, null, null, null
from DebitNotes_XmlView(1)
union select -- VATPayable
49,
41,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
VATPayable,
null, null, null, null, null
from DebitNotes_XmlView(1)
union select -- SettlementSubTotal
50,
38,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null,
SettlementSubTotal ,
null, null, null, null
from DebitNotes_XmlView (1)
union select -- DebitNoteSubTotal
51,
38,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null,
DebitNoteSubTotal,
null, null, null
from DebitNotes_XmlView(1)
union select -- VATTotal
52,
38,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
VATTotal,
null, null
from DebitNotes_XmlView(1)
union select -- SettlementDebitTotal
53,
38,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null,
SettlementDebitTotal,
null
from DebitNotes_XmlView(1)
union select -- TotalPayable
54,
38,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null,
TotalPayable
from DebitNotes_XmlView(1)
order by tag
for xml explicitLooks like a SQL Server bug. If you explicitly use the element
directive for the last five columns, it appears to work,
i.e. change
[SettlementSubTotal!50] to [SettlementSubTotal!50!element]
BTW your ORDER BY clause is correct and required, also you may
want to use UNION ALL instead of UNION (more efficient).|||Thanks for your reply.
If I do change change [SettlementSubTotal!50] to
[SettlementSubTotal!50!element] I get <SettlementSubTotal element="0.00" />
instead of <SettlementSubTotal>0.00</SettlementSubTotal>.
If I do put [DebitTotals!38!SettlementSubTotal!eleme
nt] to say that
SettlementSubTotal is an element of DebitTotals, it will come after the
VATRateTotals element (that contains other sub-elements) -- and order is
important.
This is how the <DebitTotals> bit should look like...
<DebitTotals>
<DocumentDiscountRate>0.00</DocumentDiscountRate>
<SettlementDiscountRate>0.00</SettlementDiscountRate>
<VATRateTotals>
<VATDetails>
<TaxCategory>S</TaxCategory>
<TaxRate>17.50</TaxRate>
</VATDetails>
<DiscountedLineTotals>0.00</DiscountedLineTotals>
<DocumentDiscountValue>0.00</DocumentDiscountValue>
<SettlementDiscountValue>0.00</SettlementDiscountValue>
<TaxableAmount>20.00</TaxableAmount>
<VATPayable>3.50</VATPayable>
</VATRateTotals>
<SettlementSubTotal>0.00</SettlementSubTotal>
<DebitNoteSubTotal>23.50</DebitNoteSubTotal>
<VATTotal>3.50</VATTotal>
<SettlementDebitTotal>0.00</SettlementDebitTotal>
<TotalPayable>23.50</TotalPayable>
</DebitTotals>
Is there something I can do with ORDER BY ? I'm a bit stuck now.|||Apologies, typo
[SettlementSubTotal!50] to [SettlementSubTotal!50!!element=AD]
(two exclamation marks not one)|||That's it ! Thanks for helping me. By the way, I have started using UNION AL
L
instead of UNION
- Craig|||Please disregard my earlier posting asking for the repro.
using [name!1] had a bug that we fixed in at least SQL Server 2005, don't
remember at the moment whether it is fixed in SP4 as well. Please use
[name!1!] instead.
Best regards
Michael
"Craig HB" <CraigHB@.discussions.microsoft.com> wrote in message
news:DA9542C4-1546-4814-BE5D-54259729A4F8@.microsoft.com...
> That's it ! Thanks for helping me. By the way, I have started using UNION
> ALL
> instead of UNION
> - Craig|||Yes, it is fixed in SQL Server 2000 SP4. So, either install SP4 or use the
workaround Michael provided.
Regards,
Eugene
"Michael Rys [MSFT]" <mrys@.online.microsoft.com> wrote in message
news:e1AW8F%23kFHA.320@.TK2MSFTNGP09.phx.gbl...
> Please disregard my earlier posting asking for the repro.
> using [name!1] had a bug that we fixed in at least SQL Server 2005, don't
> remember at the moment whether it is fixed in SP4 as well. Please use
> [name!1!] instead.
> Best regards
> Michael
>
> "Craig HB" <CraigHB@.discussions.microsoft.com> wrote in message
> news:DA9542C4-1546-4814-BE5D-54259729A4F8@.microsoft.com...
>