UFN_DAILYSALEITEM_BUILDDONATIONBUTTONTEXT

            CREATE function dbo.UFN_DAILYSALEITEM_BUILDDONATIONBUTTONTEXT
            (
                @ID uniqueidentifier, 
                @CURRENCYSYMBOL nchar(1)
            )

            returns nvarchar(65)
            with execute as caller
            as begin
                declare @LINESEPARATOR nchar(1) = char(10)

                declare @DESCRIPTION1 nvarchar(20)
                declare @DESCRIPTION2 nvarchar(20)
                declare @DESCRIPTION3 nvarchar(20)

                select
                    @DESCRIPTION1 = 
                        case DAILYSALEITEM.DESCRIPTIONFIELD1TYPECODE
                            when 11 then @CURRENCYSYMBOL + convert(nvarchar(20),DSID.DEFAULTAMOUNT)
                            when 12 then D.VANITYNAME
                            else DAILYSALEITEM.DESCRIPTIONFIELD1
                        end,
                    @DESCRIPTION2 = 
                        case DAILYSALEITEM.DESCRIPTIONFIELD2TYPECODE
                            when 11 then @CURRENCYSYMBOL + convert(nvarchar(20),DSID.DEFAULTAMOUNT)
                            when 12 then D.VANITYNAME
                            else DAILYSALEITEM.DESCRIPTIONFIELD2
                        end,
                    @DESCRIPTION3 = 
                        case DAILYSALEITEM.DESCRIPTIONFIELD3TYPECODE
                            when 11 then @CURRENCYSYMBOL + convert(nvarchar(20),DSID.DEFAULTAMOUNT)
                            when 12 then D.VANITYNAME
                            else DAILYSALEITEM.DESCRIPTIONFIELD3
                        end
                from dbo.DAILYSALEITEM
                inner join dbo.DAILYSALEITEMDONATION DSID on DSID.ID = DAILYSALEITEM.ID
                inner join dbo.DESIGNATION D on D.ID = DSID.DESIGNATIONID
                where DSID.ID = @ID;

                return coalesce(@DESCRIPTION1, '') + @LINESEPARATOR + coalesce(@DESCRIPTION2, '') + @LINESEPARATOR + coalesce(@DESCRIPTION3, '')
            end