UFN_SITEID_MAPFROM_NAMEFORMATPARAMETER

Map a NAMEFORMATPARAMETER to a SITEID

Return

Return Type
uniqueidentifier

Parameters

Parameter Parameter Type Mode Description
@NAMEFORMATPARAMETERID uniqueidentifier IN

Definition

Copy


create function dbo.UFN_SITEID_MAPFROM_NAMEFORMATPARAMETER(@NAMEFORMATPARAMETERID uniqueidentifier) 
returns uniqueidentifier
as
begin

    DECLARE @ID uniqueidentifier;

    SELECT @ID=SITEID from dbo.NAMEFORMATPARAMETER where ID=@NAMEFORMATPARAMETERID;

    RETURN @ID;

end