UFN_DDRETURNREVENUE_GETDESCRIPTION

Return

Return Type
nvarchar(500)
Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN
Definition

Copy


            CREATE function dbo.UFN_DDRETURNREVENUE_GETDESCRIPTION
            (
                @ID uniqueidentifier
            ) 
            returns nvarchar(500) 
            with execute as caller
            as
            begin
                declare @DESCRIPTION nvarchar(500);

                select @DESCRIPTION = TRANSACTIONTYPE + ' - ' + convert(nvarchar(10), DATE, 101)
                    from dbo.REVENUE
                    where ID = @ID

                if @DESCRIPTION is null 
                begin
                    select @DESCRIPTION = TYPE + ' - ' + convert(nvarchar(10), DATE, 101) 
                        from dbo.BATCHREVENUE 
                        where ID = @ID
                end

                if @DESCRIPTION is null 
                begin
                    select @DESCRIPTION = 'Membership - ' + convert(nvarchar(10), DATE, 101) 
                        from dbo.BATCHMEMBERSHIPDUES
                        where ID = @ID
                end

                return @DESCRIPTION;
            end