USP_USERSETTINGSLISTBUILDER_DELETEBYCONTEXTRECORD

CREATE procedure dbo.USP_USERSETTINGSLISTBUILDER_DELETEBYCONTEXTRECORD
(
    @CONTEXTRECORDID nvarchar(100) = '',
    @CONTEXTRECORDTYPE nvarchar(100)
)
as
begin
    declare @CONTEXTRECORDTYPEID uniqueidentifier = null;

    select @CONTEXTRECORDTYPEID = ID from dbo.RECORDTYPE where NAME = @CONTEXTRECORDTYPE;

    if @CONTEXTRECORDTYPEID is not null
        delete from dbo.USERSETTINGSLISTBUILDER 
        where CONTEXTRECORDTYPEID = @CONTEXTRECORDTYPEID and CONTEXTRECORDID = @CONTEXTRECORDID;

end