UFN_NOTIFICATION_ID_MAPFROM_VOLUNTEERID

Maps a VOLUNTEERID to a ID for notifications

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@VOLUNTEERID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_NOTIFICATION_ID_MAPFROM_VOLUNTEERID(@VOLUNTEERID uniqueidentifier) 
            returns uniqueidentifier
            as
            begin
                declare @ID uniqueidentifier;

                select
                    @ID = VOLUNTEER.ID
                from
                    dbo.VOLUNTEER
                where
                    VOLUNTEER.ID = @VOLUNTEERID;

                return @ID;
            end