UFN_ID_MAPFROM_WPPRIVATEFOUNDATIONID

Maps a WPPRIVATEFOUNDATIONID to a ID

Return

Return Type
uniqueidentifier

Parameters

Parameter Parameter Type Mode Description
@WPPRIVATEFOUNDATIONID uniqueidentifier IN

Definition

Copy


            create function dbo.UFN_ID_MAPFROM_WPPRIVATEFOUNDATIONID(@WPPRIVATEFOUNDATIONID uniqueidentifier) 
            returns uniqueidentifier
            as
            begin
                declare @ID uniqueidentifier;

                select @ID = WEALTH.ID from dbo.WPPRIVATEFOUNDATION
                inner join dbo.WEALTH on WEALTH.ID = WPPRIVATEFOUNDATION.WEALTHID
                where WPPRIVATEFOUNDATION.ID = @WPPRIVATEFOUNDATIONID;

                return @ID;
            end