–Select * INTO Table_A FROM Table_B;
–Select Count(*) FROM Table_A;
–Insert INTO Table_A SELECT * FROM Table_B;
DECLARE @iLoop int
DECLARE @Auto1 int
DECLARE @INDEXNO CHAR(16)=’4444555566667777′
SET @iLoop =1
SET @Auto1 = 800
WHILE @iLoop < 200
BEGIN
INSERT INTO Table_A(AA,BB,CC,DD,EE)
SELECT @INDEXNO AS AA, 1 as BB,@Auto1 as CC,DD,EE
FROM Table_B
WHERE INDEXNO = ‘1111222244446666’ AND DD = 1
SET @iLoop = @iLoop +1
SET @INDEXNO =
CAST(CAST(@INDEXNO as bigint) + 1 as char(16))
SET @Auto1 = @Auto1 + 1
END