UFN_ID_MAPFROM_WPPHILANTHROPICGIFTID

Maps a WPPHILANTHROPICGIFTID to a ID

Return

Return Type
uniqueidentifier

Parameters

Parameter Parameter Type Mode Description
@WPPHILANTHROPICGIFTID uniqueidentifier IN

Definition

Copy


            create function dbo.UFN_ID_MAPFROM_WPPHILANTHROPICGIFTID(@WPPHILANTHROPICGIFTID uniqueidentifier) 
            returns uniqueidentifier
            as
            begin
                declare @ID uniqueidentifier;

                select @ID = WEALTH.ID from dbo.WPPHILANTHROPICGIFT
                inner join dbo.WEALTH on WEALTH.ID = WPPHILANTHROPICGIFT.WEALTHID
                where WPPHILANTHROPICGIFT.ID = @WPPHILANTHROPICGIFTID;

                return @ID;
            end