UFN_SITEID_MAPFROM_APPEALID

Maps an APPEALID to a SITEID

Return

Return Type
uniqueidentifier

Parameters

Parameter Parameter Type Mode Description
@APPEALID uniqueidentifier IN

Definition

Copy


        create function dbo.UFN_SITEID_MAPFROM_APPEALID(@APPEALID uniqueidentifier) 
        returns uniqueidentifier
        as
        begin

            DECLARE @ID uniqueidentifier;

            SELECT @ID=SITEID from dbo.APPEAL where ID=@APPEALID;

            RETURN @ID;

        end