USP_DATALIST_CONSTITUENCIES

                create procedure dbo.USP_DATALIST_CONSTITUENCIES (@ID uniqueidentifier)
                as
                    set nocount on;

                    select
                        BOARDMEMBERDATERANGE.ID,
                        1 CONSTITUENCYTYPECODE,
                        CONSTITUENCYSYSTEMNAME.DESCRIPTION,
                        BOARDMEMBERDATERANGE.DATEFROM,
                        BOARDMEMBERDATERANGE.DATETO
                    from
                        dbo.BOARDMEMBERDATERANGE
                    left join
                        dbo.CONSTITUENCYSYSTEMNAME on CONSTITUENCYSYSTEMNAME.ID = 'F828E957-5F5E-479A-8F23-2FFD6C7C68FF'
                    where
                        BOARDMEMBERDATERANGE.CONSTITUENTID = @ID
                    union all
                    select
                        STAFFDATERANGE.ID,
                        2,
                        CONSTITUENCYSYSTEMNAME.DESCRIPTION,
                        STAFFDATERANGE.DATEFROM,
                        STAFFDATERANGE.DATETO
                    from
                        dbo.STAFFDATERANGE
                    left join
                        dbo.CONSTITUENCYSYSTEMNAME on CONSTITUENCYSYSTEMNAME.ID = '6093915E-ADE9-42BE-88AE-304731754467'
                    where
                        STAFFDATERANGE.CONSTITUENTID = @ID
                    union all
                    select
                        FUNDRAISERDATERANGE.ID,
                        3,
                        CONSTITUENCYSYSTEMNAME.DESCRIPTION,
                        FUNDRAISERDATERANGE.DATEFROM,
                        FUNDRAISERDATERANGE.DATETO
                    from
                        dbo.FUNDRAISERDATERANGE
                    left join
                        dbo.CONSTITUENCYSYSTEMNAME on CONSTITUENCYSYSTEMNAME.ID = 'D2DCA06A-BE6E-40B3-B95D-59A926181923'
                    where
                        FUNDRAISERDATERANGE.CONSTITUENTID = @ID
                    union all
                    select
                        PROSPECTDATERANGE.ID,
                        4,
                        CONSTITUENCYSYSTEMNAME.DESCRIPTION,
                        PROSPECTDATERANGE.DATEFROM,
                        PROSPECTDATERANGE.DATETO
                    from
                        dbo.PROSPECTDATERANGE
                    left join
                        dbo.CONSTITUENCYSYSTEMNAME on CONSTITUENCYSYSTEMNAME.ID = '00E748FB-940D-4A7D-A133-C148B29410A8'
                    where
                        PROSPECTDATERANGE.CONSTITUENTID = @ID
                    union all
                    select
                        VOLUNTEERDATERANGE.ID,
                        5,
                        CONSTITUENCYSYSTEMNAME.DESCRIPTION,
                        VOLUNTEERDATERANGE.DATEFROM,
                        VOLUNTEERDATERANGE.DATETO
                    from
                        dbo.VOLUNTEERDATERANGE
                    left join
                        dbo.CONSTITUENCYSYSTEMNAME on CONSTITUENCYSYSTEMNAME.ID = 'E7489703-3D63-4017-A2BC-88C092563C5D'
                    where
                        VOLUNTEERDATERANGE.CONSTITUENTID = @ID
                    union all
                    select
                        CONSTITUENCY.ID,
                        99,
                        CODE.DESCRIPTION,
                        CONSTITUENCY.DATEFROM,
                        CONSTITUENCY.DATETO
                    from
                        dbo.CONSTITUENCY
                    left join
                        dbo.CONSTITUENCYCODE as CODE
                    on
                        CODE.ID = CONSTITUENCY.CONSTITUENCYCODEID
                    where
                        CONSTITUENCY.CONSTITUENTID = @ID
                    order by
                        DESCRIPTION, DATEFROM, DATETO, CONSTITUENCYTYPECODE;