USP_TIMEZONEENTRYADJUSTMENTRULE_INSERT

Inserts a time zone adjustment rule record

Parameters

Parameter	Parameter Type	Mode
@TIMEZONEENTRYID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@STARTRULEDATE	datetime	IN
@ISFIXEDSTARTDATE	bit	IN
@ISFIXEDENDDATE	bit	IN
@ENDRULEDATE	datetime	IN
@STARTDAYOFWEEKCODE	tinyint	IN
@ENDDAYOFWEEKCODE	tinyint	IN
@STARTMONTHCODE	tinyint	IN
@ENDMONTHCODE	tinyint	IN
@STARTTIMEOFDAY	UDT_HOURMINUTE	IN
@ENDTIMEOFDAY	UDT_HOURMINUTE	IN
@STARTWEEKOFMONTHCODE	tinyint	IN
@ENDWEEKOFMONTHCODE	tinyint	IN
@STARTFIXEDDATE	datetime	IN
@ENDFIXEDDATE	datetime	IN
@DAYLIGHTSAVINGSDELTA	smallint	IN

Definition

Copy



create procedure dbo.USP_TIMEZONEENTRYADJUSTMENTRULE_INSERT
(
    @TIMEZONEENTRYID uniqueidentifier,    
    @CHANGEAGENTID uniqueidentifier = null,
    @STARTRULEDATE datetime,
    @ISFIXEDSTARTDATE bit,
    @ISFIXEDENDDATE bit,
    @ENDRULEDATE datetime,
    @STARTDAYOFWEEKCODE tinyint,
    @ENDDAYOFWEEKCODE tinyint,
    @STARTMONTHCODE tinyint,
    @ENDMONTHCODE tinyint,
    @STARTTIMEOFDAY UDT_HOURMINUTE,
    @ENDTIMEOFDAY UDT_HOURMINUTE,
    @STARTWEEKOFMONTHCODE tinyint,
    @ENDWEEKOFMONTHCODE tinyint,
    @STARTFIXEDDATE datetime,
    @ENDFIXEDDATE datetime,
    @DAYLIGHTSAVINGSDELTA smallint    
)
as
begin
    declare @ID uniqueidentifier

    set @ID = newid()

    if @CHANGEAGENTID is null  
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()

    begin try
        insert into dbo.TIMEZONEENTRYADJUSTMENTRULE
        (
            ID,
            TIMEZONEENTRYID,
            STARTRULEDATE,
            ISFIXEDSTARTDATE,
            ISFIXEDENDDATE,
            ENDRULEDATE,
            STARTDAYOFWEEKCODE,
            ENDDAYOFWEEKCODE,
            STARTMONTHCODE,
            ENDMONTHCODE,
            STARTTIMEOFDAY,
            ENDTIMEOFDAY,
            STARTWEEKOFMONTHCODE,
            ENDWEEKOFMONTHCODE,
            STARTFIXEDDATE,
            ENDFIXEDDATE,
            DAYLIGHTSAVINGSDELTA,
            ADDEDBYID,
            CHANGEDBYID,
            DATEADDED,
            DATECHANGED
        )
        values
        (
            @ID,
            @TIMEZONEENTRYID,        
            @STARTRULEDATE,
            @ISFIXEDSTARTDATE,
            @ISFIXEDENDDATE,
            @ENDRULEDATE,
            @STARTDAYOFWEEKCODE,
            @ENDDAYOFWEEKCODE,
            @STARTMONTHCODE,
            @ENDMONTHCODE,
            @STARTTIMEOFDAY,
            @ENDTIMEOFDAY,
            @STARTWEEKOFMONTHCODE,
            @ENDWEEKOFMONTHCODE,
            @STARTFIXEDDATE,
            @ENDFIXEDDATE,
            @DAYLIGHTSAVINGSDELTA,
            @CHANGEAGENTID,
            @CHANGEAGENTID,
            @CURRENTDATE,
            @CURRENTDATE)
        end try     
        begin catch
            exec dbo.USP_RAISE_ERROR
            return 1
        end catch            

end