topic sql insert from a load or qvd in QlikView

sql insert from a load or qvd

tameimpalan — Sat, 16 Nov 2024 18:12:25 GMT

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

Re: sql insert from a load or qvd

dapostolopoylos — Thu, 27 Aug 2020 08:50:37 GMT

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...

Re: sql insert from a load or qvd

Brett_Bleess — Thu, 03 Sep 2020 14:14:31 GMT

About the only other thing I can add is the following Help link:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptRegularStatements/Execute.htm

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