Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

Data mistmatch between SQL Query result and Pivot table

Bruno Jesus da Costa asked on February 6, 2019

Hi guys!
in some cases I get different on the same query, comparing the results on Flexmonster and SQL Studio. The correct values are in SQL output.
Attached to this message there are 2 files where we can compare the same records on both plataforms.
Can you hellp me?
Thanks in advance.

5 answers

Tanya Gryshko Flexmonster February 6, 2019

Hello, Bruno,
Thank you for writing to us.
We have noticed that the value of Empresa field is different for the records you highlighted on the screenshots. It seems that these records are actually different.
Please check and let us know if the issue is solved.

Bruno Jesus da Costa February 6, 2019

Hello Tanya,
OMG, sorry about the mistake!
Now I send the correct images.
Thanks again!

Bruno Jesus da Costa February 6, 2019

Another example!

Comparsion 2.jpg

Tanya Gryshko Flexmonster February 7, 2019

Hi Bruno!
Is it possible to send a data sample to our email?
It would be really helpful for us.

Tanya Gryshko Flexmonster April 5, 2019

Hello, Bruno,
We would like to check whether you’re still experiencing this issue.
If yes, sending a data sample to our email would greatly help us.

Please login or Register to Submit Answer