UFN_BILLINGITEM_GETDESCRIPTIONFROMPRODUCT

Gets the description of the billing item from the associated product.

Return

Return Type
nvarchar(255)

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



      create function dbo.UFN_BILLINGITEM_GETDESCRIPTIONFROMPRODUCT
      (
        @ID uniqueidentifier
      )
      returns nvarchar(255)
      with execute as caller
      as begin
        declare @RETVAL nvarchar(255);

        select @RETVAL = PRODUCT.DESCRIPTION
        from dbo.PRODUCT
        where PRODUCT.ID = @ID;

          return @RETVAL;
      end