UFN_PROSPECTSEGMENTATION_SECTIONS_SECONDARY

Gets a table of secondary variable sections for a Prospect Segmentation given a variable ID.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@VARIABLEID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_PROSPECTSEGMENTATION_SECTIONS_SECONDARY(@VARIABLEID uniqueidentifier) 
            returns table
            as return
                select
                    ID,
                    SEQUENCE,

                    LABEL,
                    RANGELOW,
                    RANGEHIGH,
                    ESTIMATEDWEALTHLOWID,
                    ESTIMATEDWEALTHHIGHID,
                    MAJORGIVINGCAPACITYLOWID,
                    MAJORGIVINGCAPACITYHIGHID,
                    TARGETGIFTRANGELOWID,
                    TARGETGIFTRANGEHIGHID,
                    WEALTHESTIMATORRATINGLOWID,
                    WEALTHESTIMATORRATINGHIGHID,

          LABEL2,
                    RANGE2LOW,
                    RANGE2HIGH,
                    ESTIMATEDWEALTH2LOWID,
                    ESTIMATEDWEALTH2HIGHID,
                    MAJORGIVINGCAPACITY2LOWID,
                    MAJORGIVINGCAPACITY2HIGHID,
                    TARGETGIFTRANGE2LOWID,
                    TARGETGIFTRANGE2HIGHID,
                    WEALTHESTIMATORRATING2LOWID,
                    WEALTHESTIMATORRATING2HIGHID

                from
                    dbo.PROSPECTSEGMENTATIONSECTION
                where
                    VARIABLEID=@VARIABLEID