UFN_SITEID_MAPFROM_APPEALDESIGNATIONID

        create function dbo.UFN_SITEID_MAPFROM_APPEALDESIGNATIONID(@APPEALDESIGNATIONID uniqueidentifier) 
        returns uniqueidentifier
        as
        begin

            DECLARE @ID uniqueidentifier;

            SELECT @ID=APPEAL.SITEID from dbo.APPEALDESIGNATION
            inner join dbo.APPEAL on APPEALDESIGNATION.APPEALID = APPEAL.ID
            where APPEALDESIGNATION.ID=@APPEALDESIGNATIONID;

            RETURN @ID;

        end