Is there a way to INSERT INTO a table from an array?
I do not have permissions for a BULK INSERT.
The array has 2 columns.
Col1 needs to be inserted into Col1 of the table.
Col2 needs to be inserted into Col2 of the table.
Can the array can be passed as a parameter into the stored procedure?
-- @arrExceptions This is the 2 column array
@SymbolID int, -- From col1,row i of the array
@Curr5DayAvg float, -- From col2,row i of the array
INSERT INTO Exceptions FROM the array.