https://community.sap.com/t5/technology-q-a/recursive-sql-in-sap-hana/qaa-p/314087#M831 <P>Hi,</P><P>SAP HANA supports CTE but not recursive SQL (no DECODE too).</P><P>The only way to do this is via SQL Script table variables (if restricted/defined in levels) procedural (Looping if indefinite levels or complex nesting rendering difficult maintenance in the future) or via separate Wrapper &amp; Executor procedures.</P><P>Refer <A href="https://archive.sap.com/discussions/thread/3384059" target="test_blank">https://archive.sap.com/discussions/thread/3384059</A> for more information.</P><P>Regards,</P><P>Kapil</P> Thu, 01 Dec 2016 16:13:35 GMT kapil_tilwani 2016-12-01T16:13:35Z https://community.sap.com/t5/technology-q-a/recursive-sql-in-sap-hana/qaq-p/314086 <P>Hi,</P><P>it is possible execute a recursive SQL command? CTE or something else?</P><P>I want to calculate multiple columns, each based on the previous column...</P><P>Thanks!</P> Thu, 01 Dec 2016 09:53:40 GMT https://community.sap.com/t5/technology-q-a/recursive-sql-in-sap-hana/qaq-p/314086 Former Member 2016-12-01T09:53:40Z https://community.sap.com/t5/technology-q-a/recursive-sql-in-sap-hana/qaa-p/314087#M831 <P>Hi,</P><P>SAP HANA supports CTE but not recursive SQL (no DECODE too).</P><P>The only way to do this is via SQL Script table variables (if restricted/defined in levels) procedural (Looping if indefinite levels or complex nesting rendering difficult maintenance in the future) or via separate Wrapper &amp; Executor procedures.</P><P>Refer <A href="https://archive.sap.com/discussions/thread/3384059" target="test_blank">https://archive.sap.com/discussions/thread/3384059</A> for more information.</P><P>Regards,</P><P>Kapil</P> Thu, 01 Dec 2016 16:13:35 GMT https://community.sap.com/t5/technology-q-a/recursive-sql-in-sap-hana/qaa-p/314087#M831 kapil_tilwani 2016-12-01T16:13:35Z