USP_DAILYSALEITEM_GETDAILYSALEITEMLIST

        CREATE procedure dbo.USP_DAILYSALEITEM_GETDAILYSALEITEMLIST
        ( @CURRENCYSYMBOL nchar(5) )
        as
        begin
            select 
                [DSI].[ID],
                [DSI].[TYPECODE],
                [DSI].[TYPE],
                case [DSI].[TYPECODE]
                    when 0 then dbo.UFN_DAILYSALEITEM_BUILDPROGRAMBUTTONTEXT(DSI.ID, @CURRENCYSYMBOL)
                    when 1 then dbo.UFN_DAILYSALEITEM_BUILDPROGRAMBUTTONTEXT(DSI.ID, @CURRENCYSYMBOL)
                    when 2 then dbo.UFN_DAILYSALEITEM_BUILDMEMBERSHIPBUTTONTEXT(DSI.ID, @CURRENCYSYMBOL)
                    when 3 then dbo.UFN_DAILYSALEITEM_BUILDDISCOUNTBUTTONTEXT(DSI.ID, @CURRENCYSYMBOL)
                    when 4 then dbo.UFN_DAILYSALEITEM_BUILDDONATIONBUTTONTEXT(DSI.ID, @CURRENCYSYMBOL)
                    when 5 then dbo.UFN_DAILYSALEITEM_BUILDEVENTREGISTRATIONBUTTONTEXT(DSI.ID, @CURRENCYSYMBOL)
                    when 6 then dbo.UFN_DAILYSALEITEM_BUILDCOMBINATIONBUTTONTEXT(DSI.ID, @CURRENCYSYMBOL)
                    when 7 then dbo.UFN_DAILYSALEITEM_BUILDMEMBERSHIPPROMOBUTTONTEXT(DSI.ID, @CURRENCYSYMBOL)
                end [BUTTONTEXT],
                DSI.[ISACTIVE],
                DSI.[BUTTONORDER],
                case [BUTTONORDER]
                    when 0 then ''
                    else convert(nvarchar(15), [BUTTONORDER])
                end [DISPLAYBUTTONORDER]
            from dbo.[DAILYSALEITEM] [DSI]
        end