hi,
i am dynamically building comma separated values to be passed in query range. It would be very big string and may go upto 8000 characters.
Can anyone please let me know what's the maximum allowed length for the queryvalue in queryrange? Thanks.
*This post is locked for comments
maximum allow limit query range is 4095chars
That's a crazy number! You shouldn't be doing anything like that!
If you tell us what business problem you're trying to solve, we should be able to suggest better technical design; one that actually will work.
It didn't work for me to do it multiple times
(as an example I send the same value several times, if I send it 2089 times it gives error)
[Microsoft] [SQL Server Native Client 10.0] [SQL Server] The remote procedure call protocol (RPC) sequence of the incoming tabular data stream (TDS) is incorrect. Too many parameters were provided in this RPC request. The maximum is 2100.
But if I send it 2088 times, it works!!
]
Hi VDY,
Refer to this blog post of mine regarding the solution suggested by Martin. You need to apply range on one field multiple times so that the result is an OR condition. This way you will not be required to pass a big string.
http://basicax.blogspot.com.au/2012/12/x-code-to-define-or-conditions-in.html
Hi Martin ,
can you please provide example?
Thanks
A TempDB table would be a good choice in this case. Also, another alternative to using a comma-separated list of values in a single range is creating several ranges (each with its own value) for the same field.
That totally depends upon your implementation either you can achieve via permanent or temporary table. Yes you are right, if you are implementing it via permanent table you can add it in QBDS.
Hope this helps you.
Is that the physical AOT table you created to dump those range values?
i guess, if it's AOT table, then only you can add it in QBDS for joining with other table.
am i right?
I created a separate table and dump my range values in it. After that I make an exists join with the newly created table containing range values with my query.
Hope this helps you
André Arnaud de Cal...
291,969
Super User 2025 Season 1
Martin Dráb
230,842
Most Valuable Professional
nmaenpaa
101,156