UFN_SITEID_MAPFROM_MEMBERSHIPPROGRAMID

Maps an MEMBERSHIPPROGRAMID to a SITEID

Return

Return Type
uniqueidentifier

Parameters

Parameter Parameter Type Mode Description
@MEMBERSHIPPROGRAMID uniqueidentifier IN

Definition

Copy


            create function dbo.UFN_SITEID_MAPFROM_MEMBERSHIPPROGRAMID
      (
        @MEMBERSHIPPROGRAMID uniqueidentifier
      )
      returns uniqueidentifier 
      as 
      begin 
        DECLARE @ID uniqueidentifier;

        SELECT @ID=SITEID from dbo.MEMBERSHIPPROGRAM where ID=@MEMBERSHIPPROGRAMID;

        RETURN @ID;

       end