SQL

A recent question in the HANA Q&A forum brought up an error message that I recently encountered myself. Modification of table variable is not supported in current SQLScript configuration The way to produce this error is… Read More » Using new features not supported?!

In Matchmaker, I developed a solution to a not-so-obvious problem. The solution worked and delivered the right answer - finding documents where the line items match to a certain degree the line items of a reference… Read More » Matchmaker - quick quick?

SQL is an easy language to learn. A few commands to learn ( SELECT/FROM/WHERE/GROUP BY) and you are good to go. One downside of the simple syntax and small vocabulary is that it can lead many SQL users to the assumption… Read More » Matchmaker

Every now and then a new version of the database software comes along. Upgrades of Oracle or MaxDB often include major improvements concerning stability and performance. These improvements can and should be read as:… Read More » Starting off with a classic…