Query not returning enough rows
Posted: Tue 11 Jun 2019 08:21
Hi,
I have a query that works fine in MS SQL Servermanagement Studio, but if I use it with the DBExpress Driver it does not return all rows. I have never had this problem with "normal" queries.
This is the query:
use bi2
select
pvt.locationid,
pvt.[1] as op1,
pvt.[4] as op2,
pvt.[5] as op3,
pvt.[9] as op4,
pvt.[27] as op5,
pvt.[11] as op6,
pvt.[28] as op7,
pvt.[12] as op8
from (
select locationid,standaardid,score from zelfevaluatie
) as temp
pivot (max(score) for standaardid in ([1],[4],[5],[9],[27],[11],[28],[12])) as pvt
Why does it not return all rows as in the Management Studio?
I use version 7.4.6.
Greetings,
Ronald
I have a query that works fine in MS SQL Servermanagement Studio, but if I use it with the DBExpress Driver it does not return all rows. I have never had this problem with "normal" queries.
This is the query:
use bi2
select
pvt.locationid,
pvt.[1] as op1,
pvt.[4] as op2,
pvt.[5] as op3,
pvt.[9] as op4,
pvt.[27] as op5,
pvt.[11] as op6,
pvt.[28] as op7,
pvt.[12] as op8
from (
select locationid,standaardid,score from zelfevaluatie
) as temp
pivot (max(score) for standaardid in ([1],[4],[5],[9],[27],[11],[28],[12])) as pvt
Why does it not return all rows as in the Management Studio?
I use version 7.4.6.
Greetings,
Ronald