So, now I can read the XML file 🙂

I removed the namespace and changed the sql script.

DECLARE @x xml

SELECT @x = T

FROM OPENROWSET (BULK 'C:\temp\01-06-2016.xml', SINGLE_BLOB) AS Terrorliste(T)

DECLARE @hdoc int

EXEC...

I have to throw in the towel.

Perhaps you can help me all the way. Have used google but find nothing useful.

In advance, thank you for your help 🙂

Thanks for answer.

Well, Spelling should be in place now, but no change i result.

DECLARE @x xml

SELECT @x = T

FROM OPENROWSET (BULK 'C:\temp\01-06-2016Copy.xml', SINGLE_BLOB) AS Terrorliste(T)

DECLARE @hdoc int

EXEC sp_xml_preparedocument @hdoc OUTPUT,...

So, I hope this is done in the right way.

This should be the ddl and sample data. I have not made ddl before.

'Business Volume

USE [LF_Drift]

GO

/****** Object: Table [dbo].[LF$Business...

Well, I´m not sure if I can rephrase my question, but I try.

I have 3 tables

Table: User Setup (as US)

Fields: User ID, Department

Table contains all our users and where they...