User Activity

We found an inconsistent behaviour in the group by clause. The essence of a huge SQL boils down to the following effect: In the SQL below the first GROUP BY gives the error message:Wrong column number. Too large value 12345 as select list column refe...
We have a table with the relation of users and teams with the duration.-- given data|USR |TEAM |BEG_DATE |END_DATE ||daniel|team_A|2021-09-01|2021-09-30||daniel|team_B|2021-10-01|2021-10-31||daniel|team_C|2021-11-01|2021-12-31|I want to create an add...
In our DWH we added for every Code-Field (ending in _c) the corresponding Short and Long-Description (ending in kbez_x, lbez_x) as separate fields. In the example below e.g inkasso_typ_c, inkasso_typ_kbez_x, inkasso_typ_lbez_x. Unfortunatly there are...
Kudos given to