Host variable SELECT FROM SFLIGHT FIELDS planetype, "Column specified directly from DB table SFLIGHT~price, "Coulum selector used to set colunm name if multiple data sources in ABAP SQL 'AIR FRANCE' ...

And although we did not define any hierarchy attributes in the element list of the CDS hierarchy, we can add all the hierarchy columns listed under Hierarchy Columns to the SELECT list of our ABAP SQL ...

I'm doing this in a stored proc using SQL Server.<BR><BR>Basically, I'm executing 1 SELECT statement and if that returns any rows then I want to do a SELECT INTO #Temp With criteria A.