UFN_SITEID_MAPFROM_CORRESPONDENCECODE

Maps a CORRESPONDENCECODE to a SITEID

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@CORRESPONDENCECODEID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_SITEID_MAPFROM_CORRESPONDENCECODE(@CORRESPONDENCECODEID uniqueidentifier) 
            returns uniqueidentifier
            as begin

                declare @ID uniqueidentifier;

                select @ID = SITEID 
                from dbo.CORRESPONDENCECODE 
                where ID = @CORRESPONDENCECODEID;

                return @ID;

            end