UFN_SITEID_MAPFROM_DONORCHALLENGEID

Maps an DONORCHALLENGEID to a SITEID

Return

Return Type
uniqueidentifier

Parameters

Parameter Parameter Type Mode Description
@DONORCHALLENGEID uniqueidentifier IN

Definition

Copy


        create function dbo.UFN_SITEID_MAPFROM_DONORCHALLENGEID(@DONORCHALLENGEID uniqueidentifier) 
        returns uniqueidentifier
        as
        begin

            DECLARE @ID uniqueidentifier;

            SELECT @ID=SITEID from dbo.DONORCHALLENGE where ID=@DONORCHALLENGEID;

            RETURN @ID;

        end