Page 1 of 1

Query not returning enough rows

Posted: Tue 11 Jun 2019 08:21
by dbxsda445src
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

Re: Query not returning enough rows

Posted: Tue 11 Jun 2019 10:22
by dbxsda445src
Solved. A dumb mistake of mine, I tested it on a testserver but ran the testscript on a productionserver.
Sorry.