Guy Thiebaut (3/27/2013)

---

Nice article.
Only comment I would add is that I find your indentation makes the code difficult to read for me.

So with this:

   FROM #MyTable v,
        (--==== Derived table "fs" finds ID of the first row 
             -- where stanation of VALUE occurs
         SELECT MIN(ID) AS FirstIDOfStagnation
           FROM #MyTable v,
...

I find the following easier to read

SELECT v.*
FROM #MyTable v,
	(--==== Derived table "fs" finds ID of the first row 
        -- where stanation of VALUE occurs
        SELECT MIN(ID) AS FirstIDOfStagnation
        FROM #MyTable v,
...

nick.mcdermaid (3/27/2013)

---

Are you kidding me? someone posts into a discussion on forum etiquette asking a new question and breaking most of the rules of forum etiquette in the process!


Anyway.... I'm suprised sqlfiddle isn't used more to assist in setting up a test bed - it's all over Stackoverflow.com. I guess people like to have the source in the question, not in another site.

http://sqlfiddle.com/


My forum posting has got to the point where I will post a very general answer just to work out whether the original poster is even giong to get back to the question, before I fully engage in answering.