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