I have a table in which I need to insert over 100 rows, each with only one unique value between them. Currently, I am using an INSERT statement to put in one row at a time which is becoming increasingly frustrating. It looks like this

```
INSERT INTO tblTableName
    (columnName1, columnName2, columnName3, columnName4)
VALUES
    (sameData1, sameData2, sameData3, variableIntegerData)

```

For each new entry I make into the table, i replace variableIntegerData and execute the code.

Is there a way i can have my data in a one dimension array (which could look like this)

```
(907, 908, 875, 876, 878, 885 ...) 

```

And then run the code so it inserts a line for each element in that array? I have considered making a temporary table to store the data however that would just be double handling anyway.

Any help on this would be appreciated, thank you in advance!