SAP Factory Calendar in Snowflake
Using the SAP Factory Calendar table TFACS in Snowflake.
Using the SAP Factory Calendar table TFACS in Snowflake.
How to make HANA process more than 2bn records without partitioning? No average feat!
You want to apply your business logic to multiple tables in your DB but don’t want to use dynamic SQL? Good on you! Here’s how.
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.
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!
Ever mixed timestamps and dates and wondered why your result wasn’t quite what you expected?
Find one possible answer to this in this blog post.
Looking for the content of Lars’ presentation from #sitMEL-2020? Look no further, it’s all here.
In which I deal with non-obvious type conversion problems and NULLs.
How do implement unique constraints for only some of the table entries in SAP HANA.