USP_DESIGNATIONS_GETCHILDREN

Accepts a list of designations and returns their children

Parameters

Parameter	Parameter Type	Mode	Description
@parentIDsList	nvarchar(2000)	IN

Definition

Copy



                CREATE procedure [dbo].[USP_DESIGNATIONS_GETCHILDREN]
                (
                    @parentIDsList nvarchar(2000)
                )
                as
                set nocount on
                select designationid from [dbo].UFN_DESIGNATIONS_GETCHILDREN (@parentIDsList)