Find the ONE … or the other
Some “finger-exercises” in data modeling, SQL programming, and making sense of ABAP design decisions.
data modeling
Matchmaker – quick quick?
You’ve come up with a clever SQL to solve a problem but now you want to make it fast?
No worries! This post shows how I shaved off 50% runtime and memory by copy & paste.
Matchmaker
Finding alternative order-documents where the lineitems match a certain percentage of a reference document? In SQL? With no cursors? See how it’s done!
The time is now, isn’t it?
Doing calculations with dates in your queries? Better read this post and make sure your code does what you think it does.
Conditionally unique
How do implement unique constraints for only some of the table entries in SAP HANA.