Hi Shaulbel

Deleting from the CTE will delete the data from the underlying table. This link should explain more:

http://stackoverflow.com/questions/6010233/delete-rows-from-cte-in-sql-server

I prefer using temp tables so you can double-check what you're deleting before...

Hi Mike,

Glad it was useful!

Regards,

Mike.

Hi Irfan

Yes, your method is completely valid. The article is just trying to demonstrate how to use the OVER() clause, as there's a thought not enough people are aware of...

Hi Robert

With a corrected Version Number, it's relatively straightforward to set the end date of the current row to the start date of the following row.

E.g.:

FieldVersion: 3, StartDate: 2016-04-06 09:00,...

Hi Sam - yes, your method is valid too. There are plenty of ways to do this kind of thing, I'm just trying to give an overview of how the...

Hi Dave

Thanks for taking the time to read the article. When you have (as in your example), a v1 and two v3 values, all you can do is make a...

Hi nzhang6666

Good to hear you are following along, and sorry to hear you had some trouble with the files. I've just had a check and I've noticed that I don't...

Hi Mike

Thanks for these comments - much appreciated.

I will try to work these into a future article.

Regards,

Mike.

Hi Mike

Thanks very much for your updates. I'll take a look and will update this article in the next week or so.

Regards,

Mike.

Hi Chris

You are spot on, this is a typo on my part (must have written that part on the train!). It's even more frustrating as I actually say the full...

Hi David

You're quite right - that will teach to use direct file URIs!

Thanks for digging out the updated link. I'll have a word to see if the article can be...

Here's a third option to go with files and RDBMS's...

I've successfully used NoSQL systems, like MongoDB and CouchBase, to store logs in the past. These are quick to write to...

Hello

I'm afraid this was a mistake on my part - I'd somehow uploaded the wrong file. I've just replaced it, try the one that's there now.

Sorry about that.

Regards,

Mike.

Hi there

The files are still at their original location, it's possible the link in the article is incorrect (I'll investigate that).

You can download them from here

Regards,

Mike.

Glad you're enjoying the series. Quite a few articles to come yet...

Regards,

Mike.