Data mistmatch between SQL Query result and Pivot table

Answered
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.
Bruno 

5 answers

Public
Tanya Gryshko 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.
Regards,
Tanya

Public
Bruno Jesus da Costa February 6, 2019

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

Public
Bruno Jesus da Costa February 6, 2019

Another example!

Attachments:
Comparsion 2.jpg

Public
Tanya Gryshko 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.
Thanks,
  Tanya

Public
Tanya Gryshko 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.
 
Regards,
Tanya

Please login or Register to Submit Answer