Try this one

SELECT 
   V.[ID],
   V.[ReferenceID],
   V.[ReferenceType],
   V.[Enddate]

FROM [MyDB].[dbo].[V_MyView] V
except

 SELECT
    T.[CustomerID],
    T.[RelatedReferenceID],
...

You may not have this luxury in every venue but I ended up working in a short description of what was meant by beginner or intermediate into the session description.

Something...

That's because you essentially have a one to many link between the class and vat rates level, and you're only returning the first one.  That's what the [1] is doing...

Understood - but I'm not getting into a lost cause debate about having Microsoft change one of its core assumptions since the early 90's for SQL server:  simply pointing out...

• This reply was modified 6 years, 8 months ago by Matt Miller (4).

As in :

select 
fields.value('(../ns3:DummyValueMessageHeader/ns3:TransactionType)[1]', 'varchar(100)') AS TransactionType
,fields.value('(../ns3:DummyValueMessageHeader/ns3:CreationDateTime)[1]', 'datetime2(7)') AS CreatedDate
,fields.value('(ns2:Sync/@actionCode)[1]', 'varchar(100)') AS actionCode
,fields.value('(ns4:MerchandiseHierarchy/ns4:MerchandiseMasterDivision/*:ChainNumber)[1]', 'varchar(100)') AS ChainNumber
,fields.value('(ns4:MerchandiseHierarchy/ns4:MerchandiseMasterDivision)[1]', 'varchar(100)') AS MerchandiseMasterDivision
from @x.nodes('//SyncMerchandiseHierarchyRequest/SyncMerchandiseHierarchy') as xmldata(fields)

This is a "quick and dirty" trick, but simply add *: in front of ChainNumber in your query.  Of course that will work assuming no 2 of your namespaces have...

To answer your question specifically, this is a good thread to read through.  https://stackoverflow.com/questions/364253/how-to-deserialize-xml-document

That said if your main goal is to simply explode the XML and save it back...

Unfortunately - I don't think STRING_SPLIT will work From the BOL for String_split:

The output rows might be in any order. The order is not guaranteed to match the...

Unfortunately - I don't think STRING_SPLIT will work

From the BOL for String_split:

The output rows might be in any order. The order is not guaranteed to match the order of the...

I'm not entirely...

• This reply was modified 6 years, 8 months ago by Matt Miller (4).

I'm not sure what the Grace Hopper setup is. And posting powerpoint slides is kinda worthless if one subscribes to the belief that powerpoint should supplement the presentation, not...

Grant Fritchey wrote:

Brandie Tarvin wrote:

Alright, Threadzians. Who's responsible for this one? https://www.zdnet.com/article/faulty-database-script-brings-salesforce-to-its-knees/ Seriously. What were they thinking and why didn't they test this first?  

Cause the vast majority of people out...

• This reply was modified 6 years, 8 months ago by Matt Miller (4).

I think you're making this complicated - by conflating two separate processes.  One is the schedule of earnings (how much from each policy is earned in each accounting period).  You'll...

I think andy 's solution might help.  One thing I just noticed is that you have a namespace definition on the not you're triny to use as your anchor, which...

Try this:

select [Tx].[value]('(salestermsoutputs[1]/policy[1]/CoverType)[1]', 'nvarchar(100)')  AS x
,quote
FROM TEMPDYNAMICPRICINGTEST X
outer Apply Quote.nodes('ComponentEvent/EventPayload/AggregatorEventPayload/Policy/Versions/PolicyVersion/RiskItems/RiskItem/SalesTermsDetails') [ClvInc]([Tx]);