By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table Table1 (Sum int, Count int, Name1 varchar(10), Address1 varchar(10), Zip1 varchar(10));
create table Table2 (Name varchar(10), Address varchar(10), Zip varchar(10));
insert into Table2 (Name, Address, Zip) values
('Name1', 'Address1', 'Zip1'),
('Name2', 'Address2', 'Zip2'),
('Name3', 'Address3', 'Zip3'),
('Name4', 'Address4', 'Zip4');
Records: 4 Duplicates: 0 Warnings: 0
INSERT INTO Table1 (Sum, Count, Name1, Address1, Zip1)
SELECT SUM(t2.rn) OVER (ORDER BY t2.rn),
t2.rn, t2.Name, t2.Address, t2.Zip
FROM (SELECT *, ROW_NUMBER() OVER () AS rn FROM Table2) t2;
Records: 4 Duplicates: 0 Warnings: 0
SELECT * FROM Table1
| Sum | Count | Name1 | Address1 | Zip1 |
|---|---|---|---|---|
| 1 | 1 | Name1 | Address1 | Zip1 |
| 3 | 2 | Name2 | Address2 | Zip2 |
| 6 | 3 | Name3 | Address3 | Zip3 |
| 10 | 4 | Name4 | Address4 | Zip4 |