I have a table of play data that I'm using for a prototype. I'm generating the data while I'm at work, but when I leave and my machine goes to sleep, the data generation stops. This has cause large gaps in my collection of items.

I would like to be able to shift the values of each item in the DateTimeCreated collumn of my table so that there isn't a gap of more than 10 minutes between any item and the next generated item.

I was thinking about doing this in L2S, but I have over 1 million records, so IDK if that is the best solution (iterating over each item). I know there has to be some way to do this in SQL that will be much faster. Any guidance would be great!

@Dems - I only have 10-15 gaps of ~12 hours in each gap. I'd like to maintain the "randomness" of the currently generated data's datetime. I'm pulling data from organic sources (random tweets, facebook posts, etc) so I'd like to keep as much of the organicness as possible. But, in the end, I'm open to anything :)
–
joe_coolishJan 23 '12 at 20:45