USP_APPUSERCLAIMS_UPDATE_ISREGISTERED

      CREATE procedure dbo.USP_APPUSERCLAIMS_UPDATE_ISREGISTERED
      (
        @APPUSERID uniqueidentifier,
        @ISREGISTERED bit
      )
      as
      begin
        update dbo.APPUSERCLAIMS
        set ISREGISTERED = @ISREGISTERED
        where
          APPUSERID = @APPUSERID and
          ISREGISTERED <> @ISREGISTERED;

        update dbo.APPUSERCLAIMSLINK
        set ISREGISTERED = @ISREGISTERED
        where
          APPUSERID = @APPUSERID and
          ISREGISTERED <> @ISREGISTERED;
      end