Could you just use change data capture, or any traditional type of trigger-based auditing to...

Nice, and thanks for giving me an inferiority complex about my signature now... 🙂 Seriously, though, you guys are the best. I'll refrain from offering forum advice for awhile, but...

Fascinating article! I have a couple of naive questions about the following bit of G code:

Adjacency (NodeID, ParentID) as -- Adjacency Query

...

Wayne, yes, thank you. That explains it completely. So, using your example of a time "80101", the code would (working from the inside out) transform it thusly:

80101 (original)

10108 (reversed)

10:108 (stuff...

Sorry for the late reply, I didn't get the usual email notifying me of a new post.

Thanks, G! I think that did it! I'd love to see your "outer apply...

1. Craig, can I have an autographed photo of your brain for Chistmas?

2. This is totally cool. I'm trying to figure it all out. I think I'm doing pretty well....

Awesome, got it. Thanks! I've taken up a good deal of your time today, Craig!

Okay, I think this is starting to make sense now. Contiguous is defined here as "at least one date entry per day during a range". Okay. And now the rest...

But how can you tell which dates are "start", "end" or "start and end" without any additional information (like the comments)? I don't see any rhyme or reason here, aside...

Sorry, I'm dumb. But I completely don't understand how the "test data" dates at the start of the article make any sense without the accompanying comments. Would you mind clarifying...

First, thanks to the two kind gents who offered explanations. I've read them each a dozen times and, while they make sense on their own, I'm still working to correlate...

sharath.chalamgari (11/30/2010)

---

Simple and nice article,

some time back i was working on validating a column in the database and i came across this issue and we had this function to...

456789psw (11/24/2010)

---

so again ....its sounds like sql does not have enough memory and running on disk...my guess is if you look in your task manager...you have a lot of other...

456789psw (11/24/2010)

---

sound like the disk is running .....when you are not really doing anything within sql server....its just up and running in the background...you are not hitting it with any...

I'm sorry, CirquedeSQLeil, but I literally don't even understand most of what your last post was asking. My computer has 2GB memory. I have a few test/sample databases including AdventureWorks...