-- Create a table to store the parsed data
CREATE TABLE EolResultData (
    ID INT IDENTITY(1,1) PRIMARY KEY,
    OrderID NVARCHAR(100),
    DateTime NVARCHAR(100),
    TestName NVARCHAR(100),
    ValueName NVARCHAR(100),
    Value NVARCHAR(100)
);

-- Declare XML variable and insert data into the table
DECLARE @xml XML = '
<eolresults>
    <eolresult>
        <eolpresetting>
            <datetime>08.12.2020 5:24:48</datetime>
            <order id="2049457704XSK316_FRX101xxxxxxxxxxxxxx000SK35X3PH9P40006C24A4NORL0L7P7XYA0000006T24D0XXK0006A00000000" />
        </eolpresetting>
    </eolresult>
    <eolresult>
        <eolpresetting>
            <datetime>09.12.2020 6:30:12</datetime>
            <order id="2049457704XSK316_FRX102xxxxxxxxxxxxxx000SK35X3PH9P40006C24A4NORL0L7P7XYA0000006T24D0XXK0006A00000001" />
        </eolpresetting>
    </eolresult>
</eolresults>';

INSERT INTO EolResultData (OrderID, DateTime, TestName, ValueName, Value)
SELECT
    xml_data.value('(eolpresetting/order/@id)[1]', 'NVARCHAR(100)') AS OrderID,
    xml_data.value('(eolpresetting/datetime)[1]', 'NVARCHAR(100)') AS DateTime,
    xml_data.value('(eolpresetting/variableinfo/testname)[1]', 'NVARCHAR(100)') AS TestName,
    xml_data.value('(eolpresetting/variableinfo/valuename)[1]', 'NVARCHAR(100)') AS ValueName,
    xml_data.value('(eolpresetting/variableinfo/value)[1]', 'NVARCHAR(100)') AS Value
FROM @xml.nodes('/eolresults/eolresult/eolpresetting') AS x(xml_data);

-- Query the inserted data
SELECT * FROM EolResultData;