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;