Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
tameimpalan
Contributor
Contributor

sql insert from a load or qvd

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, column2VALUES (a, 1);

b,2, INSERT INTO database.dbo.table (column1, column2VALUES (b, 2);

c,3, INSERT INTO database.dbo.table (column1, column2VALUES (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

Labels (1)
2 Replies
dapostolopoylos
Creator III
Creator III

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

Father/Husband/BI Developer
Brett_Bleess
Former Employee
Former Employee

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

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.