USP_DATALIST_PLANNEDGIFT_VEHICLEOPTIONS
Returns all options for planned gift vehicles
Definition
Copy
CREATE procedure dbo.USP_DATALIST_PLANNEDGIFT_VEHICLEOPTIONS
as
set nocount on;
select
ID,
VEHICLE,
AUTOCALCULATEREALIZEDAMOUNT
from dbo.PLANNEDGIFTVEHICLEOPTIONS
order by
case VEHICLECODE
when 13 then 1 -- Display Other last
else 0
end;