USP_RECORDSECURITYIDMAP_REGISTERNULLSECURITYVIEW

create procedure dbo.USP_RECORDSECURITYIDMAP_REGISTERNULLSECURITYVIEW
(
    @FROMRECORDTYPE nvarchar(50),
    @TORECORDTYPE nvarchar(50),
    @NULLSECURITYVIEW nvarchar(255),
    @CHANGEAGENTID uniqueidentifier = null
)
as
begin
    set nocount on;

    declare @CURRENTDATE datetime = getdate();
    if @CHANGEAGENTID is null
        exec dbo.[USP_CHANGEAGENT_GETORCREATECHANGEAGENT] @CHANGEAGENTID output;

    update dbo.[RECORDSECURITYIDMAP]
    set
        [RECORDSECURITYIDMAP].[NULLSECURITYVIEW] = @NULLSECURITYVIEW,
        [RECORDSECURITYIDMAP].[CHANGEDBYID] = @CHANGEAGENTID,
        [RECORDSECURITYIDMAP].[DATECHANGED] = @CURRENTDATE
    where
        [RECORDSECURITYIDMAP].[FROMRECORDTYPE] = @FROMRECORDTYPE
        and [RECORDSECURITYIDMAP].[TORECORDTYPE] = @TORECORDTYPE;

    if @@ROWCOUNT = 0
    begin
        raiserror('Failed to register the null security view. The mapping may not exist.', 13, 1);
    end
end