CREATE TABLE  DATA_LOG (
	[id] [bigint] NOT NULL,
	[obj_id] [int] NULL,
	[parent_obj_id] [int] NULL,
	[obj_name] [varchar](255) NOT NULL,
	[val] [varchar](8000) NOT NULL
)

CREATE CLUSTERED INDEX IX_DATA_LOG ON DATA_LOG
([id] ASC,[obj_id] ASC)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) 

CREATE NONCLUSTERED INDEX IX_OBJ ON DATA_LOG
([obj_name] ASC)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
DECLARE @CNT INT = 1, @MAX BIGINT = 0;
SET @CNT = 1
SET @MAX = (SELECT MAX(id) FROM DATA_LOG);

WHILE @CNT > 0
BEGIN

INSERT INTO DATA_LOG 
SELECT TOP 500000 WITH TIES A.[id],A.[obj_id],A.[parent_obj_id],A.[obj_name],A.[val]
FROM SOURCE_TABLE (NOLOCK) AS A
INNER JOIN HIST_TABLE AS B ON A.id = B.id
WHERE (B.STAGE_CODE= 'FINAL_REQUEST') AND (B.id> @MAX)
ORDER BY A.id ASC

SET @CNT = @@ROWCOUNT
END

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
CREATE TABLE #FINAL_REQUEST (id BIGINT)
CREATE UNIQUE CLUSTERED INDEX i_id ON #FINAL_REQUEST (id)
DECLARE @CNT INT = 1, @MAX BIGINT = 0;

WHILE @CNT > 0
BIGINT

TRUNCATE TABLE #FINAL_REQUEST	
SET @MAX = (SELECT MAX(id) FROM DATA_LOG (NOLOCK));
INSERT INTO #FINAL_REQUEST
SELECT TOP 300 id FROM HIST_TABLE  WHERE id > @MAX AND STAGE_CODE= 'FINAL_REQUEST	' ORDER BY id

INSERT INTO DATA_LOG
SELECT A.[id],A.[obj_id],A.[parent_obj_id],A.[obj_name],A.[val]
FROM #FINAL_REQUEST AS B
INNER JOIN SOURCE_TABLE  (NOLOCK) AS A ON A.id= B.id
ORDER BY A.id ASC

SET @CNT = @@ROWCOUNT
END

DECLARE @Max bigint = (SELECT MAX(id) FROM A1)

INSERT INTO A1
SELECT A.id, A.obj_name, D.[id] AS [index], B.val
FROM (select id from only_id where id > @Max and id <= @MAX + 500 ) AS E
INNER JOIN DATA_LOG AS C ON (E.id = C.id) AND (C.obj_name = 'WORK')
INNER JOIN DATA_LOG AS A ON A.id = E.id AND (c.obj_id = a.parent_obj_id)
INNER JOIN DATA_LOG AS B ON (A.id = B.id) AND (A.obj_id = B.parent_obj_id)
INNER JOIN DIM_INDEX AS D ON D.obj_name = B.obj_name
WHERE (A.obj_name in ('INN','COMPANY_NAME','ADDRESS'))
AND A.id > @Max 
AND B.id > @Max 
AND C.id > @Max 
OPTION(RECOMPILE)

DECLARE @Max bigint = (SELECT MAX(id) FROM A2)

INSERT INTO A2
SELECT A.id, A.obj_name, D.[id] AS [index], B.val
FROM (select id from only_id where id > @Max and id <= @MAX + 500 ) AS E
INNER JOIN DATA_LOG AS C ON (E.id = C.id) AND (C.obj_name = 'CLIENT')
INNER JOIN DATA_LOG AS A ON A.id = E.id AND (c.obj_id = a.parent_obj_id)
INNER JOIN DATA_LOG AS B ON (A.id = B.id) AND (A.obj_id = B.parent_obj_id)
INNER JOIN DIM_INDEX AS D ON D.obj_name = B.obj_name
WHERE (A.obj_name in ('SURNAME','NAME','BIRTHDAY'))
AND A.id > @Max 
AND B.id > @Max 
AND C.id > @Max 
OPTION(RECOMPILE)

DECLARE @Max bigint = (SELECT MAX(id) FROM A2)

INSERT INTO A2
SELECT A.id, A.obj_name, D.[id] AS [index], B.val
FROM (select id from only_id where id > @Max and id <= @MAX + 500 ) AS E
INNER JOIN DATA_LOG  [color=red](NOLOCK)[/color] AS C ON (E.id = C.id) AND (C.obj_name = 'CLIENT')
INNER JOIN DATA_LOG  [color=red](NOLOCK)[/color] AS A ON A.id = E.id AND (c.obj_id = a.parent_obj_id)
INNER JOIN DATA_LOG  [color=red](NOLOCK)[/color] AS B ON (A.id = B.id) AND (A.obj_id = B.parent_obj_id)
INNER JOIN DIM_INDEX AS D ON D.obj_name = B.obj_name
WHERE (A.obj_name in ('SURNAME','NAME','BIRTHDAY'))
AND A.id > @Max 
AND B.id > @Max 
AND C.id > @Max 
OPTION(RECOMPILE)