UFN_BILLINGITEM_GETNAMEFROMPRODUCT

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

Return

Return Type
nvarchar(100)

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



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

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

                  return @RETVAL;
              end