Skip to content

sql

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!

Types of NULL

In which I deal with non-obvious type conversion problems and NULLs.