UFN_GIFTFEE_GETCONSTITUENCIES

Returns all constituencies for gift fee.

Return

Return Type
table

Definition

Copy



            create function dbo.UFN_GIFTFEE_GETCONSTITUENCIES()
            returns table
            as
            return
            (
                select
                    ID,
                    coalesce(USERCONSTITUENCYCODEID, SYSTEMCONSTITUENCYID) CONSTITUENCYID
                from
                    dbo.GIFTFEECONSTITUENCY
            );