CREATE PROCEDURE [dbo].[spLoad]
AS
BEGIN
  SET NOCOUNT ON;

  TRUNCATE TABLE tAppeals;

  DECLARE @appeal_id nvarchar(100);
  DECLARE @open_time datetime;
  DECLARE @close_time datetime;

  DECLARE appeals_cursor CURSOR FOR
    SELECT INCIDENT_ID, OPEN_TIME, CLOSE_TIME
    FROM OPENQUERY([server], 'SELECT [INCIDENT_ID], [OPEN_TIME], [CLOSE_TIME]
                                                   FROM [base].[dbo].[table]
                                 ')
 
  OPEN appeals_cursor

  FETCH NEXT FROM appeals_cursor INTO @appeal_id, @open_time, @close_time

  WHILE @@FETCH_STATUS = 0
  BEGIN
       DECLARE @new_open_time datetime;
       DECLARE @new_close_time datetime;
       DECLARE @final_close_time datetime;

       SET @final_close_time = @close_time;
       SET @new_open_time = @open_time;

       WHILE DATEPART(month, @new_open_time) < DATEPART(MONTH, @close_time)
       BEGIN
           SET @new_close_time = CONCAT(CONVERT(nvarchar(10), CONVERT(date, EOMONTH(@open_time))), ' ' +  '23:59:59.000')

           INSERT INTO tAppeals (appeal_id, open_time, close_time) VALUES(@appeal_id, @open_time, @new_close_time)

           SET @new_open_time = DATEADD(MONTH, 1 + DATEDIFF(MONTH, 0, @open_time), 0);
            SET @open_time = @new_open_time;
       END;

       IF DATEPART(month, @new_open_time) = DATEPART(MONTH, @close_time)
           INSERT INTO tAppeals (appeal_id, open_time, close_time) VALUES(@appeal_id, @open_time, @final_close_time)

       FETCH NEXT FROM appeals_cursor INTO @appeal_id, @open_time, @close_time
  END
CLOSE appeals_cursor
END;
GO