Problem-solving without a Teradata Recursive Query In our example, we want to represent a corporate hierarchy. Without recursion, this can be done, e.g., with the query shown below: SELECT — Concatenation of all Companies CASE WHEN Level >= 3 THEN TRIM(t03.Company_Id) || ‘.’ ELSE ” END || CASE WHEN Level >= 2 THEN TRIM(t02.Company_Id) ||

Read More