USP_DATALIST_GIFTFEECONSTITUENCY

                CREATE procedure dbo.USP_DATALIST_GIFTFEECONSTITUENCY
                as begin
                set nocount on;

                select
                    GIFTFEECONSTITUENCY.ID,
                    CONSTITUENCYDEFINITION.DESCRIPTION as CONSTITUENCY,
                    CONSTITUENCYDEFINITION.ISACTIVE as CONSTITUENCYISACTIVE
                from 
                    dbo.GIFTFEECONSTITUENCY
                    inner join dbo.CONSTITUENCYDEFINITION on coalesce(GIFTFEECONSTITUENCY.SYSTEMCONSTITUENCYID,GIFTFEECONSTITUENCY.USERCONSTITUENCYCODEID) = CONSTITUENCYDEFINITION.ID                    
                order by 
                    CONSTITUENCY;

                end