you say if you split up the query for a month into 2, it works okish/fine

is the result fine if you split it up the query into these 2 and...

What keeps me employed is i am the only one knowing (coping with) our BI System (8000 employees).

I finished studying one year ago and started without work experience with SQL...

Not being used sounds like a weird reason to remove this button

Even if its not used often, its the OP's fault, but the the use itself is there

Thanks, will take a look into this

You get 2 results because of the

ELSE 'EN-DD'

The else clause misses in 5 of 6 of your @table results, so you get the following result:

1x PT-BR

5x EN-DD

5x...

I have encountered this problem aswell, im not sure why my solution works but i guess i post it here, maybe it helps someone.
The reason i got this error...

stupid me, the solution is as simple as it sounds
the  table created by activating write back is based on values that are in the cube already, i changed the...

reposted topic in correct subforum
https://www.sqlservercentral.com/Forums/2015811/Writeback-Values-bigger-than-Int-allows

Happy new year
The last thing i could be thinking of is that because the number of rows created with this container varies from below 100 to up to 15...

Now im actually confused, when i run at step its 1:30 hours aswell, compared to yesterdays 23mins

is it some kind of caching issue?

edit: while executing the...

here is the result of the next day, when the container is run as part of the full job, compared to when run yesterday with "Start Job at step.."