UFN_DISCOUNT_GETNAME

Returns the name of a discount based on ID

Return

Return Type
nvarchar(100)

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



      CREATE function dbo.UFN_DISCOUNT_GETNAME(@ID uniqueidentifier)
      returns nvarchar(100)
      with execute as caller
      as begin
          declare @NAME nvarchar(100);

          if exists(select 1 from dbo.MEMBERSHIPPROMO where ID = @ID)
            select @NAME = [NAME] from dbo.[MEMBERSHIPPROMO] where [ID] = @ID;

          else
            select @NAME = [NAME] from dbo.[DISCOUNT] where [ID] = @ID;


          return coalesce(@NAME,'')
      end