USP_DATALIST_TARGETGIFTRANGES

Returns a list of all target gift ranges in the system.

Definition

Copy


                CREATE procedure dbo.USP_DATALIST_TARGETGIFTRANGES
                as
                    set nocount on;

                    select
                        TGR.ID,
                        TGR.SCORE,
                        TGR.RANGE,
                        TGR.MINIMUMAMOUNT
                    from
                        dbo.TARGETGIFTRANGE TGR
                    order by
                        TGR.SCORE asc;