lmu92 (1/23/2010)
Did you notice that you've got two answers with sample code after that short time?The reason is simple: You provided ready to use sample data! Well done! 🙂
Cent percent for the OP for putting together the data in a consumable format and suprisingly this was her first visit here on SSC it seems ...
Having two almost identical solutions seems to be an indicator that either both of us are hitting in the wrong direction or the concept of the solution isn't that bad... 😉
Or too much of CTEs in our minds these days..:-D I have seen lot of your solutions making use of CTE's lutz 🙂
---------------------------------------------------------------------------------