CREATE TABLE [dbo].[al_reevaluate_block_id]
(
[block_id] [int] NOT NULL,
[reset_to_flag] [int] NOT NULL CONSTRAINT [DF__al_reeval__reset__00776F28] DEFAULT ('2'),
[last_update_user] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL CONSTRAINT [DF__al_reeval__versi__016B9361] DEFAULT ('0')
) ON [PRIMARY]
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE TRIGGER dbo.al_c_al_reevaluate_block_id
ON dbo.al_reevaluate_block_id
INSTEAD OF INSERT
AS
    declare @block_id int
    declare @reset_to_flag int
    declare @last_update_user nvarchar(255)
    declare @last_update_date int
    declare @version_number int
    declare @count int

    select    @block_id = block_id,
            @reset_to_flag = reset_to_flag,
            @last_update_user = last_update_user,
            @last_update_date = last_update_date,
            @version_number = version_number
    from inserted

    --If block_id is null, we can ignore the insertion
    if @block_id is null
        return

    --Check if this row exists and return if found
    set @count = (select count(*) from dbo.al_reevaluate_block_id
        where block_id = @block_id and reset_to_flag = @reset_to_flag)
    if @count > 0
        return

    --Fill in optional columns as needed
    if @last_update_date is null
        set @last_update_date = datediff(ss, '1/1/1970', getutcdate())
    if @last_update_user is null
        set @last_update_user = SYSTEM_USER + '(al_c_al_reevaluate_block_id)'

    --Insert the row
    insert into al_reevaluate_block_id (block_id, reset_to_flag, last_update_user, last_update_date, version_number)
        values(@block_id, @reset_to_flag, @last_update_user, @last_update_date, @version_number)

GO
GRANT SELECT ON  [dbo].[al_reevaluate_block_id] TO [swcmadmin]
GRANT INSERT ON  [dbo].[al_reevaluate_block_id] TO [swcmadmin]
GRANT DELETE ON  [dbo].[al_reevaluate_block_id] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[al_reevaluate_block_id] TO [swcmadmin]
GRANT SELECT ON  [dbo].[al_reevaluate_block_id] TO [uapmadmin_group]
GRANT INSERT ON  [dbo].[al_reevaluate_block_id] TO [uapmadmin_group]
GRANT DELETE ON  [dbo].[al_reevaluate_block_id] TO [uapmadmin_group]
GRANT UPDATE ON  [dbo].[al_reevaluate_block_id] TO [uapmadmin_group]
GRANT SELECT ON  [dbo].[al_reevaluate_block_id] TO [uapmbatch_group]
GRANT INSERT ON  [dbo].[al_reevaluate_block_id] TO [uapmbatch_group]
GRANT DELETE ON  [dbo].[al_reevaluate_block_id] TO [uapmbatch_group]
GRANT UPDATE ON  [dbo].[al_reevaluate_block_id] TO [uapmbatch_group]
GRANT SELECT ON  [dbo].[al_reevaluate_block_id] TO [uapmreporting_group]
GO