USP_DATALIST_DAILYSALESGENERICACTION

CREATE procedure dbo.USP_DATALIST_DAILYSALESGENERICACTION
as
    set nocount on;

    select
        [ID],
        [TYPE],
        [ISACTIVE],
        [BUTTONORDER],
        case [BUTTONORDER]
            when 0 then ''
            else convert(nvarchar(15), [BUTTONORDER])
        end [DISPLAYBUTTONORDER]
    from dbo.UFN_DAILYSALESGENERICACTION_GETGENERICBUTTONS(1)
    order by [TYPE]