UFN_DESIGNATION_GETDESIGNATIONMAPPING

Returns all designation rows that have the specified DesignationLevel1ID.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@DESIGNATIONLEVEL1ID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_DESIGNATION_GETDESIGNATIONMAPPING
            (
                @DESIGNATIONLEVEL1ID uniqueidentifier
            )
            returns table            
            as            
            return 
                select 
                    DESIGNATION.ID,
                    dbo.UFN_DESIGNATION_BUILDNAME(DESIGNATION.ID) as DESIGNATION,
                    ACCOUNTNUMBER,
                    PROJECTCODE
                from dbo.DESIGNATION
                where
                    (DESIGNATIONLEVEL1ID = @DESIGNATIONLEVEL1ID);