Operation Details |
Description: | Returns all sub-columns for a parent column by index and returns full rate column details. |
Sterotype: | nsmulti |
SQL |
SELECT rateColumnID, rateHeaderID, parentColumnID, rateColumnKeyMin, rateColumnKeyMax, rateColumnKeyValue, rateColumnType, rateColumnIndex, anyMaximumInd, anyMinimumInd INTO :rateColumnID, :rateHeaderID, :parentColumnID, :rateColumnKeyMin, :rateColumnKeyMax, :rateColumnKeyValue, :rateColumnType, :rateColumnIndex, :anyMaximumInd, :anyMinimumInd FROM RateColumn WHERE parentColumnID = :rateColumnID AND ( rateColumnIndex >= :index ) ORDER BY rateColumnType, rateColumnIndex ASC |