title: How to implement hierarchy or recursive CTE in SAP HANA 1.2v
body: <p>Im working on SAP HANA 1.2v.
  I have a db table containing employee id and manager id.
  Now i need to find circular references or internal looping within table between employee and managers.for instance 
  A manager is B
  B manager is C
  C manager is A
  In above example you can  see there is a loop i need to eliminate this.
  But i see recursive cte is not possible in sap hana and also hierarchy function is allowed only from hana 2.0.
  Can some one please help me how to solve this..
  Any suggestions highly appreciated.</p>