hana | Your standard library | SDK library

Edward is correct. IFF is not available on this specific SQL server. CASE is portable across all SQL platforms whereas IIF is SQL SERVER 2012+ specific.

Replacing the IIF with a CASE is the correct solution and functions mostly the same.

Use array notation to combine the ranges, and combine them with either filter() or query() to remove the empty rows.

Filter docs

Query docs

You could try fetching the table control via getTableAsync from the value help dialog:

I know very little about the ctre library so I've probably used some clumsy constructs below, but it's hopefully good enough to get somewhere. I've commented inline to explain what it's doing.

Try any of these:

type_c is a variable template that creates a value of type type. It indeed seems like Foo should easily deduce parameter _T from type<_T> when passing type. However it is not possible because type is an alias template that refers to member of some auxiliary class and its parameter is always in non-deduced context.

On SQL Server you may try the following:

There are two separate issues.

• join_view's restriction on joining ranges of prvalue ranges is a defect in C++20 that has been corrected by P2328R1. transform(make) | join should Just Work on a standard library implementing the defect resolution (such as libstdc++ trunk).

• hana::always returns different things depending on whether it is invoked as an lvalue or rvalue. It returns an lvalue reference when invoked as an lvalue and a prvalue when invoked as an rvalue. transform always invokes as lvalue, while your static_assert is checking the result of invoking as rvalue.

A home-made solution.

XML-template: