I have table:

```
        opendt        enddt         Id
        ------------------------------
        2013-01-20    2013-02-20    1
        2013-02-20    2014-02-06    1
        2013-02-28    NULL          1

```

Ideally for record #2 we should have `enddt = 2013-02-28` but instead it is `2014-02-06` by mistake. I want to find such records where `enddt` is not equal to next row `opendt` for same `ID`. I know I can try finding this by using `temp` tables. Is there is a way to do this without `temp` table? SQL 2012