USE Base 
DECLARE @STR NVARCHAR(MAX) SET @STR ='КРУГ'  
DECLARE @STR1 NVARCHAR(MAX) SET @STR1 = 'КРУГ ТЕСТ' 
DECLARE @user NVARCHAR(15) SET @user='ТЕСТ'
DECLARE @curD DATETIME SET @curD='01.08.2018 15:05:29' 
DECLARE @I BIGINT SET @I=1
WHILE @I!=0
 BEGIN
	SELECT @I= (SELECT MIN(ID_NKN)FROM Book WHERE (IM LIKE '%'+@STR+'%')AND(FLAG_A='1'))
	INSERT INTO Table1 (a1,a2,a3,a4, ID_U,D_U,FLAG_A) 
	SELECT a1,a2,a3,a4,@user,@curD,'2'
	FROM Table1
	WHERE (ID=@I) AND (FLAG_A='1')
	INSERT INTO Table2(b1, b2, b3)
	SELECT  b1, b2, b3, @user, @curD,'2',@@IDENTITY
	FROM Table2
	WHERE ID=@I
	UPDATE Table1
	SET FLAG_A=0, D_E=@curD, ID_U=@user
	WHERE ID=@I
	UPDATE Table2
	SET FLAG_A=0, D_E=@curD, ID_U=@user
	WHERE ID_NKN=@I
 END;
UPDATE Table1 SET a1 = (SELECT REPLACE(a1, @STR, @STR1)) 
WHERE (a1 LIKE '%'+@STR+'%') AND (FLAG_A='2')
UPDATE Table1
SET FLAG_A = 1
WHERE FLAG_A=2
SELECT B.ID, B.a1,B.a2,,J.b1,J.b2,J.b3
FROM Table1 AS B LEFT JOIN Table2 AS J
ON B.ID=J.ID
WHERE (B.FLAG_A='1') AND (IM LIKE '%'+@STR+'%')
ORDER BY B.ID