By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
DECLARE @xmlDocument xml;
SET @xmlDocument = N'<STRUCTURE>
<GRILLE>
<ROWS>
<ROW>
<NU_LINE>1</NU_LINE>
<CHAMPS>
<CHAMP KEY="NUMBER" LABEL="AAA" API_NAME="AAA" API_FIELD="BBB" VALUE="ABC123" />
<CHAMP KEY="RES" LABEL="AAA" API_NAME="AAA" API_FIELD="BBB" VALUE="JAMES" />
<CHAMP KEY="DATE_BEGIN" API_NAME="CCC" API_FIELD="BBB" VALUE="14/08/2021" />
<CHAMP KEY="DATE_END" API_NAME="CCC" API_FIELD="BBB" VALUE="28/08/2021" />
</CHAMPS>
</ROW>
<ROW>
<NU_LINE>2</NU_LINE>
<CHAMPS>
<CHAMP KEY="NUMBER" LABEL="ABC" API_NAME="DDD" API_FIELD="EEE" VALUE="CDE345" />
<CHAMP KEY="DATE_RES" LABEL="CDE" API_NAME="DDD" API_FIELD="EEE" VALUE="06/05/2021" />
<CHAMP KEY="RES" LABEL="DEF" API_NAME="DDD" API_FIELD="EEE" VALUE="JOHN" />
<CHAMP KEY="DATE_BEGIN" API_NAME="DDD" API_FIELD="EEE" VALUE="07/08/2021" />
<CHAMP KEY="DATE_END" API_NAME="DDD" API_FIELD="EEE" VALUE="14/08/2021" />
</CHAMPS>
</ROW>
<ROW>
<NU_LINE>3</NU_LINE>
<CHAMPS>
<CHAMP KEY="NUMBER" LABEL="OOO" API_NAME="FFF" API_FIELD="GGG" VALUE="EFG567" />
<CHAMP KEY="DATE_RES" LABEL="OOO" API_NAME="FFF" API_FIELD="GGG" VALUE="10/05/2021" />
<CHAMP KEY="RES" LABEL="OOO" API_NAME="FFF" API_FIELD="GGG" VALUE="JIM" />
<CHAMP KEY="DATE_BEGIN" API_NAME="FFF" API_FIELD="GGG" VALUE="24/07/2021" />
<CHAMP KEY="DATE_END" API_NAME="FFF" API_FIELD="GGG" VALUE="31/07/2021" />
</CHAMPS>
</ROW>
</ROWS>
</GRILLE>
</STRUCTURE>';
| NU_LINE | KEY | LABEL | API_NAME | API_FIELD | VALUE |
|---|---|---|---|---|---|
| 1 | NUMBER | AAA | AAA | BBB | ABC123 |
| 1 | RES | AAA | AAA | BBB | JAMES |
| 1 | DATE_BEGIN | null | CCC | BBB | 14/08/2021 |
| 1 | DATE_END | null | CCC | BBB | 28/08/2021 |
| 2 | NUMBER | ABC | DDD | EEE | CDE345 |
| 2 | DATE_RES | CDE | DDD | EEE | 06/05/2021 |
| 2 | RES | DEF | DDD | EEE | JOHN |
| 2 | DATE_BEGIN | null | DDD | EEE | 07/08/2021 |
| 2 | DATE_END | null | DDD | EEE | 14/08/2021 |
| 3 | NUMBER | OOO | FFF | GGG | EFG567 |
| 3 | DATE_RES | OOO | FFF | GGG | 10/05/2021 |
| 3 | RES | OOO | FFF | GGG | JIM |
| 3 | DATE_BEGIN | null | FFF | GGG | 24/07/2021 |
| 3 | DATE_END | null | FFF | GGG | 31/07/2021 |