Here it is.

Yes, we do have tape. I thought that the process to to roll back would be quite simple, because the process to get the tape is not always simple. :hehe:

Thanks.

Thank you for bad news.

Thank you very much for excellent explanation! 🙂

Thank you one more time. I think that example with CTE1 is most flexible.

Wow, what a fast response.

Thank you, Andras, for good idea.:)

Thanks a lot.

Thank you every one for suggestions. I think the best solution is:

select CustomerID

from ReportB

group by CustomerID

having Max([Year]*12+Month)- Min([Year]*12+[Month])+1 <> Count(*)

Thank you everyone.

I found good solution:

SELECT a.desc, min(a.id) id1, min(b.id) id2, min(c.id) id3

FROM  your_table a

LEFT JOIN   your_table b   ON   a.id <...

This does not work because this numbers are just as an example. In fact, there are 3000 rows in a table, and each Desc can...