USP_DATALIST_TITLECODEDEFAULTS

                CREATE procedure dbo.USP_DATALIST_TITLECODEDEFAULTS(    
                    @INCLUDEINACTIVE bit = 0,
                    @ID uniqueidentifier = null)

                as
                    set nocount on;

                        select    
                            TITLECODE.ID,
                            TITLECODE.DESCRIPTION,
                            TITLECODE.ACTIVE,
                            coalesce(TITLECODECONFIGURATION.GENDER, 'Any')
                        from 
                            dbo.TITLECODE
                        left join 
                            dbo.TITLECODECONFIGURATION on TITLECODECONFIGURATION.ID = TITLECODE.ID
                        where
                            (@INCLUDEINACTIVE = 1 or TITLECODE.ACTIVE = 1)
                            and (@ID is null or TITLECODE.ID = @ID)
                        order by
                            case when dbo.UFN_GETLISTSORTMETHOD('TITLECODE') = 1 then TITLECODE.SEQUENCE else 0 end,
                            TITLECODE.DESCRIPTION;