hi,

I tried to understand your example but I didn't.

I have no idea how you get to the date values for the added rows. And what about the first row in your example, the date values have changed there too.

Please try to explain it again, maybe more detailled.

By the way, please read the following article and provide your example data a little bit more comfortable 😉

http://www.sqlservercentral.com/articles/Best+Practices/61537/