Combines the rows whose Period values either meet or overlap so that the resulting normalized row contains the earliest beginning bound and the latest ending bound from the Period values of all the rows involved.
Syntax
[TD_SYSFNLIB.] TD_NORMALIZE_OVERLAP_MEET ( grouping_column_list, period_column )
- grouping_column_list
- One or more grouping columns, not including the Period column. You must specify the input as a dynamic UDT.
- period_column
-
Any expression that evaluates to a Period data type.
The Period expression must be comparable with the other expression. Implicit casting to a Period data type is not supported.
- TD_SYSFNLIB.
- Name of the database where the function is located.