USP_DATAFORMTEMPLATE_VIEW_DEFAULTTIMEZONEENTRY

create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_DEFAULTTIMEZONEENTRY
(
    @DATALOADED bit = 0 output,
    @TIMEZONEENTRYID uniqueidentifier = null output,
    @DISPLAYNAME nvarchar(200) = null output,
    @NAME nvarchar(200) = null output,
    @ACTIVE bit = null output,
    @BASETIMEZONEOFFSET smallint = null output
)
as
    set nocount on;

    -- be sure to set this, in case the select returns no rows
    set @DATALOADED = 0;

    select 
        @TIMEZONEENTRYID = TIMEZONEENTRY.ID,
        @DATALOADED = 1,
        @DISPLAYNAME = TIMEZONEENTRY.DISPLAYNAME,
        @NAME = TIMEZONEENTRY.NAME,
        @ACTIVE = TIMEZONEENTRY.ACTIVE,
        @BASETIMEZONEOFFSET = TIMEZONEENTRY.BASETIMEZONEOFFSET
    from 
        dbo.TIMEZONEENTRY
        inner join dbo.INTERNATIONALIZATIONINFO on TIMEZONEENTRY.ID = INTERNATIONALIZATIONINFO .DEFAULTTIMEZONEENTRYID

    return 0;