UFN_SITEID_MAPFROM_LETTERTEMPLATEID

Maps a letter template ID to a site ID.

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@LETTERTEMPLATEID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_SITEID_MAPFROM_LETTERTEMPLATEID
            (
                @LETTERTEMPLATEID uniqueidentifier
            ) 
            returns uniqueidentifier
            as
            begin
                declare @ID uniqueidentifier;

                select @ID = SITEID
                from dbo.LETTERTEMPLATE
                where ID = @LETTERTEMPLATEID;

                return @ID;
            end