I'm a fairly regular Stack Overflow answering user and a new user for this specific community of Database Administrators.
Yesterday I was scraping through the open issues and decided to attempt helping a guy having problems with a query, with a workaround to their schema design. Op's was satisfie...
Your "Table 2" mapping won't help you for this task, because it holds non-useful association between A values and B values (A1 is matched with B1 and B2. A2 is matched with B3 and B4).
What you can do here is generate an ad-hoc remapping with ranking values using three window functions:
ROW_NUMB...
Reminds me of the chess engine's ?? Blunder. If it's marked as such, you don't get an explanation why, you have to find out.
@SeanGallardy nah don't think so. I heard it second hand from our ERP consultant at the time. I'm guessing he was referring to Damgaard Data. Didn't realize IBM was involved too, I envisioned a small shop project.
I will say, I liked AX better than the ERP system we use at my current place. Idk how ours can be accurate with how poorly written the code is (at least in the database side), and the intricacies they chose when architecting the database. But all ERP systems I've seen so far are jungles regardless.
@SeanGallardy Yea I believe it. There's too many intricacies ERP systems need to account for. Probably could never pay me enough to build one from the ground up. I'll happily complain about other people's code who have though. 😆
What does REALLY "rubberducking" mean, in fact? Quite a riddle, isn't it?
Would you consider SQLite to be beginner-friendly for a person that is otherwise quite familiar with Python? DB usage being simple and trivial compared to the app's business logic, just a few basic requests to handle user stuff.
I have to disagree with your opinion on nobody supposedly liking regex. Regex is a tool, and in many instances, it is THE tool. Powerful and precise, yet nuanced enough to have driven many people to temporarily lose their marbles. And regardless, the added bonus of being a master-key joke -- say anything remotely witty, or even just snarky that involves the word "regex", and one out of three computer developers will laugh like they have heard the best joke in their life. Win-win scenario.