Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
howdy folks,
i'm having troube running an sqlserver insert from a table w/ approximately 2kk rows and it's because i run, for each line of the table, an insert line.
for example:
column 1, column 2,statement
a, 1, INSERT INTO database.dbo.table (column1, column2) VALUES (a, 1);
b,2, INSERT INTO database.dbo.table (column1, column2) VALUES (b, 2);
c,3, INSERT INTO database.dbo.table (column1, column2) VALUES (c, 3);
with this method, it takes eternity to finish the proccess.
i know that in sql, we can do this:
INSERT INTO database.dbo.table SELECT * FROM database.dbo.table2
in a nutshell: is there a way so i can insert the lines on an similar format to the one above?
somthing like: SQL INSERT INTO database.dbo.table LOAD * FROM table2
I am not sure if you can do this, what i know for sure is that you can write back to the db any table object created in a document using a macro, i have seen a solution like this a few years ago in a older job i had...
About the only other thing I can add is the following Help link:
Not sure I am following what you are really trying to do here, and I suspect that may account for the lack of more responses, so if you can clarify things further, that may help.
I believe there is also going to be potential restrictions in the DB connector side/DB security that may prevent things too, just FYI.
Regards,
Brett