USP_LOGOUTUSERFROMOTHERSESSIONS

create procedure dbo.USP_LOGOUTUSERFROMOTHERSESSIONS ( @ID int,
@FORMTICKETID uniqueidentifier=null)
as
  begin            
      declare @TMPTICKETS TABLE(ID uniqueidentifier,CACHEKEY varchar(50))

       insert into @TMPTICKETS
       select ID,'FormTicket:'+convert(varchar(36),ID)   
       from   dbo.CLIENTUSERIDENTITYINFO(nolock)
       where  CLIENTUSERID=@ID
       and    
          1=(case when @FORMTICKETID is null then 1
                  when @FORMTICKETID is not null and ID<>@FORMTICKETID then 1
                  else 0 end);

          delete dbo.CLIENTUSERIDENTITYINFO from dbo.CLIENTUSERIDENTITYINFO CUID
          join @TMPTICKETS TT on CUID.ID=TT.ID

          delete dbo.CACHEITEMS from dbo.CACHEITEMS CI
          join @TMPTICKETS TT on CI.[KEY]=TT.CACHEKEY

       select CACHEKEY from @TMPTICKETS;
end;