UFN_CONSTITUENTSUMMARY_GETSELECTEDTILES

            CREATE function dbo.UFN_CONSTITUENTSUMMARY_GETSELECTEDTILES(
                @APPUSERID uniqueidentifier,
                @CONSTITUENTTYPECODE tinyint
            )
            returns table
            as
            return
            (
                select
                    CONSTITUENTSUMMARYSELECTEDTILE.ID,
                    CONSTITUENTSUMMARYAVAILABLETILE.DATAFORMINSTANCECATALOGID TILEID,
                    CONSTITUENTSUMMARYSELECTEDTILE.SEQUENCE,
                    CONSTITUENTSUMMARYSELECTEDTILE.CONSTITUENTSUMMARYAVAILABLETILEID
                from dbo.CONSTITUENTSUMMARYSELECTEDTILE
                    inner join dbo.CONSTITUENTSUMMARYAVAILABLETILE on CONSTITUENTSUMMARYAVAILABLETILE.ID = CONSTITUENTSUMMARYSELECTEDTILE.CONSTITUENTSUMMARYAVAILABLETILEID
                where CONSTITUENTSUMMARYSELECTEDTILE.APPUSERID = @APPUSERID
                    and CONSTITUENTSUMMARYAVAILABLETILE.CONSTITUENTTYPECODE = @CONSTITUENTTYPECODE
            )