USP_DATALIST_SALESMETHODDONATION

Lists the availability of donations for each sales method.

Definition

Copy


            CREATE procedure dbo.USP_DATALIST_SALESMETHODDONATION
            as
            set nocount on;

                select
                    ID,
                    DONATIONAVAILABLE,
                    case
                        when DONATIONAVAILABLE = 1 then
                            'RES:checkmark'
                        else
                            'RES:do_not_symbol'
                    end ALLOWIMAGE,
                    TYPE
                from
                    dbo.SALESMETHOD
                order by
                    TYPECODE;

                return 0;