使用存储过程插入多行

使用此存储过程 (SQL Server)：

ALTER PROCEDURE [dbo].[fill_table1]
    @CreatedBy nvarchar(max) = NULL
AS
BEGIN
    SET NOCOUNT ON;

    SELECT
        [IdExchangeRate] = NEWID(),
        [ExchangeRateCode] = 'EUR',
        [ExchangeRatePeriodStartDate] = period,
        [ExchangeRatePeriodEndDate] = EOMonth(period),
        [ExchangeRateValue] = B.Value,
        [CurrencyCode] = A.[Currency Code],
        [CreatedBy] = 'string',
        [CreatedAt] =  GETUTCDATE()
    FROM
        [TempExchangeRates] AS A
    CROSS APPLY
        (SELECT
             period = TRY_CONVERT(date),
             Value = TRY_CONVERT(float, value) 
              ......) B
END

我想将此输出（+100 行）插入到另一个表（表 2）中。我试过了，但它只插入了一行。