Thanks for your reply. but it's not exactly what i try to do to see if response times are better.

When you use bulk import, you have your xml in one...

Thanks for your help.

That works fine.

Here the complete storeprocedure which could be useful.

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:Frederic Leurs
-- Create date: 2020/01/07
-- Description:Delete or archive rows...

Thanks for you contribution. I know  path, explicit or Auto. I have just made a simple example in a couple of minutes. In the real life, it's always a little...

thanks a lot. It was so simple. You are right : it was a basic problem.

Is there an another way to get the result of a for XML ( without...

Same thinks without a table

select cast((
select distinct
1 as Tag,  
    0 as Parent,
    convert(varchar(10), getdate(), 103) as [Header!1!DateStock!ELEMENT],
'103' as [Header!1!FormatDate!ELEMENT],
...