Forum Discussion
Doubled values in query
Hi,
Ask your colleague to input his credentials on your computer. If the output will be correct then you should analyse sql if the views providing data have some restrictions based on user login. If not, try to just load data from both systems and compare tables one to one.
It is always tricky to find what's the reason for cases like this.
Artur
Unfortuantely, my colleague is on the other side of the world, so using their credentials on my computer isn't possible, but the SQL doesn't appear to contain any code relating to login.
Definitely tricky, but putting the table side by side shows exactly what I've described; the rows have the same descriptive values but the amount value is doubled exactly 2x.
Guess I'll keep looking through settings that might cause it.