You are very welcome.

😎

Just a quick note, do use the text() function when extracting element values, it is much more efficient than extracting the values without...

Here is a quick example, should be enough to get you over this hurdle.

😎

USE TEEST;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.XMLwithOpenXML') IS NOT NULL DROP TABLE dbo.XMLwithOpenXML;

CREATE TABLE dbo.XMLwithOpenXML

(

Id...

I have unraveled such situations quite few times, always some nice surprises;-)

😎

Two questions, what is the isolation level used? What is the ratio of optimization time outs?

Can you post an example of the XML please?

😎

Not what I meant

😎

To clarify, skip this

WITH XMLNAMESPACES (

'urn:digi-inkoop:ubl:2.0:NL:1.6:UBL-NL-CommonBasicComponents-2' AS [nl-cbc],

'urn:un:unece:uncefact:data:draft:UnqualifiedDataTypesSchemaModule:2' AS udt,

'urn:oasis:names:specification:ubl:schema:xsd:CommonExtensionComponents-2' AS ext,

'urn:oasis:names:specification:ubl:schema:xsd:CommonBasicComponents-2' AS cbc,

'urn:oasis:names:specification:ubl:schema:xsd:CommonAggregateComponents-2'...

Quick suggestion, skip the namespaces and use a wildcard *: prefix instead.

😎

@shift is a scalar variable, you are probably better of splitting the content or do some other...

Do you want...

I would think very carefully about this before implementing

😎

1) Will there be more indices on the table than the clustered index?

2) Will the clustered index key be foreign key in...

Here is a suggestion

😎

DECLARE @shift VARCHAR(100) = 'Afternoon Shift (FMF/SVP)';

DECLARE @Table TABLE

(

code VARCHAR(10)

,Description VARCHAR(100)

...

He he, didn't read the post properly:w00t:

😎

Can you post an example of the XML stored in the @RichTests variable?

richard.wanamaker (11/24/2016)

INSERT INTO [dbo].RichTest

SELECT doc.col.value('(.)[1]', 'nvarchar(50)')

FROM @RichTests.nodes('/macs/mac') AS doc(col)

WHERE NOT EXISTS (SELECT 1 FROM [RichTest] WHERE [Name] = doc.col.value('(.)[1]', 'nvarchar(50)')

Getting this:

System.Data.SqlClient.SqlException: Database 'Doc' cannot be opened because...

Gazareth (11/24/2016)

Eirikur Eiriksson (11/24/2016)

Gazareth (11/24/2016)

BWFC (11/24/2016)

ThomasRushton (11/24/2016)

BLOB EATER (11/24/2016)

GilaMonster (11/24/2016)

The office kitchen also caters to stranger tastes, with 3 types of tea...

RonKyle (11/23/2016)

In most cases there isn't one. I would certainly never use an SSN for this. But that doesn't mean that...