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;