USP_ADDCLIENTUSERSLOGINHISTORY

create procedure dbo.USP_ADDCLIENTUSERSLOGINHISTORY
(
@USERID int,
@USERAGENT varchar(1000),
@DATELASTLOGIN datetime
)
as    
    begin
      declare @CHANGEAGENTID UNIQUEIDENTIFIER;
        exec dbo.Usp_changeagent_getorcreatechangeagent @CHANGEAGENTID OUTPUT;

        declare @DATE datetime
        set @DATE = Getdate()
        insert into dbo.CLIENTUSERSLOGINHISTORY(
                                                [USERID],
                                                [USERAGENT],
                                                [DATELASTLOGIN],
                        [ADDEDBYID],
                                              [CHANGEDBYID],
                                              [DATEADDED],
                                              [DATECHANGED]
                                                )
                                                values(
                                                @USERID,
                                                @USERAGENT,
                                                @DATELASTLOGIN,
                        @CHANGEAGENTID,
                                              @CHANGEAGENTID,
                                              @DATE,
                                              @DATE 
                                                );

        ----After Insert

        delete from dbo.CLIENTUSERSLOGINHISTORY
                where ID not in(
                                select top 10 ID 
                                from dbo.CLIENTUSERSLOGINHISTORY(nolock)
                                where USERID=@USERID
                                order by DATELASTLOGIN desc)
                                and USERID=@USERID;

    end;