SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
DECLARE @SchemaName sysname = N'dbo',
        @TableName sysname = N'YourTable';

DECLARE @not xml = '<Data>
  <MgRec>
    <Recipient>10800234</Recipient>
    <Recipient>24900005</Recipient>
    <Recipient>24900004</Recipient>
    <Recipient>10201026</Recipient>
    <Recipient>66600019</Recipient>
    <Recipient>14042243</Recipient>
  </MgRec>
</Data>';

DECLARE @SQL nvarchar(MAX);
SET @SQL = '
CREATE TABLE ' + QUOTENAME(@SchemaName) + N'.' + QUOTENAME(@TableName)+ N'
(
    Adr VARCHAR(1000)
)
INSERT INTO ' + QUOTENAME(@SchemaName) + N'.' + QUOTENAME(@TableName)+ N' (Adr)
SELECT Recipient.value(''(./text())[1]'',''varchar(15)'')
FROM @not.nodes(''Data/MgRec'' ) xmlData(ref)
     CROSS APPLY ref.nodes(''Recipient'') AS Recipients(Recipient) ;';
EXEC sys.sp_executesql @SQL, N'@not xml', @not;
6 rows affected

SELECT *
FROM dbo.YourTable;


Adr


10800234

24900005

24900004

10201026

66600019

14042243


DROP TABLE dbo.YourTable;