USP_DATALIST_TIMEZONEENTRY

                CREATE procedure dbo.USP_DATALIST_TIMEZONEENTRY
                (
                    @INCLUDEINACTIVE bit = 0
                )
                as
                set nocount on;

                    select TIMEZONEENTRY.ID,
                           TIMEZONEENTRY.DISPLAYNAME,                  
                           TIMEZONEENTRY.ACTIVE,
                           case when [I].[ID] is null then 0 else 1 end [DEFAULT]                           
                    from dbo.TIMEZONEENTRY
                        left outer join dbo.[INTERNATIONALIZATIONINFO] [I] on [TIMEZONEENTRY].[ID] = [I].[DEFAULTTIMEZONEENTRYID]
                    where
                        @INCLUDEINACTIVE = 1 or
                        ACTIVE = 1
                    order by 
                        TIMEZONEENTRY.SEQUENCE