DECLARE @InputQuery NVARCHAR(2000) = N'
SELECT n, cast(o as float)
FROM (values (1,10.1), (2,20.2), (3,30.3), (4, 40.4)) a(n, o)
WHERE n < 4
';
INSERT dbo.TwoNumbers
EXEC sp_execute_external_script
@language =N'Python',
@script=N'OutputDataSet = InputDataSet',
@input_data_1 = @InputQuery
SELECT tn.LowNumber, tn.HighNumber FROM dbo.TwoNumbers AS tn;