SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Table1
(A varchar(7),B varchar(20),C varchar(20));

INSERT INTO Table1 (A, B,C)
VALUES
('106091', '1071101001','Q'),
('106100', '1071101002','W'),
('106104', '1071101003','E'),
('107091', '1071101001','R'),
('107100', '1071101002','T'),
('107104', '1071101003','A'),
('107105', '1071101004','S'),
('107106', '1071101005','D'),
('107107', '1071101006','F'),
('107180', '1071101007','G');

SELECT *
FROM Table1;


A
B
C


106091
1071101001
Q

106100
1071101002
W

106104
1071101003
E

107091
1071101001
R

107100
1071101002
T

107104
1071101003
A

107105
1071101004
S

107106
1071101005
D

107107
1071101006
F

107180
1071101007
G


INSERT INTO Table1 (A,B,C)
SELECT A,B,C
FROM Table1
FULL OUTER JOIN (SELECT TOP (299) 1 AS ROWNUM
FROM master..spt_values) AS P ON 1=1;
2990 rows affected

SELECT COUNT(1) ROWCOUNTER
FROM Table1;


ROWCOUNTER


3000

A	B	C
106091	1071101001	Q
106100	1071101002	W
106104	1071101003	E
107091	1071101001	R
107100	1071101002	T
107104	1071101003	A
107105	1071101004	S
107106	1071101005	D
107107	1071101006	F
107180	1071101007	G