SQL Connection 1000 Limit

Anonymous — Tue, 30 Jun 2015 14:40:40 GMT

Hi,

I made an sql connection in QV however there is a max limit of extracting 1,000 rows only. I think it's a limit set in Sql from backend. I have 50,000 employee IDs that I need to fetch, I can't be running the query 50 times. Any sugestion to overcome this problem?

Example of a query is as follows, ideally I would want to enter 50,000 person IDs in the query and extract the data in 1 go.

select * from V_GLOBAL_EXPE where person_id in ('204095','204002046','2040066','24005535','2007641','2070790','2023055','10018307','2016832','2007638','223608','103028','100069')

Thanks

Sunny

Re: SQL Connection 1000 Limit

marcus_sommer — Tue, 30 Jun 2015 19:37:43 GMT

If you have really a hard row-limit from the database you will have no other choice as to run your queries more than one time maybe within a loop. But of course it's a bad idea to run each time the same query. I suggest you used an incremental approach stored the interim results in qvd's and queries the next time only these id's which you didn't have loaded already.

- Marcus

topic SQL Connection 1000 Limit in QlikView

SQL Connection 1000 Limit

Re: SQL Connection 1000 Limit