We use cookies on our website to analyze website usage and to help secure the website against misuse. Advertising and functional cookies are not used in our site or our web application products.
By clicking “Accept Essential Cookies Only”, you consent to us placing these cookies.
Build a temp table containing all descendants of an entity in a hierarchy
Traverses the specified entity hierarchy starting from one or more key IDs and writes all descendant records into a new temp table. Returns the temp table name in the result buffer. Consider using the dbo.f_ChildLocationIDs function as a lighter alternative.
| Parameter | Description |
|---|---|
| cmd | TempTableName |
| Argument 0 | Entity |
| Argument 1 | Key |
| Argument 2 | Parent Key/Starting Key or 0 to build the whole hierarchy |
CreateHierarchyTempTable "TempTableName", "Entity", "Key", "Parent Key/Starting Key or 0 to build the whole hierarchy"