This tutorial will help you learning SQL Server Profiler...

thank you for answer

waw, how you get that round computation Leszek, is it some kind of algorithm or your experiences got you to this ? I'd never think like this

v2 <br> finally this script gives correct data for dishdy and Leszek sample data in decent time

v2 2008R2 ok, just found and used Stefan_G's trick to materialize data

v2 2008R2 ok, just found and used Stefan_G's trick to materialize data

wrong or slow on different dataset

Huh, actually it is slow not because of recursive cte but all calculation and steps before recursive cte

Maxim is your solution for MS2012 or 2008? anyway can you share this for me? I posted solution with correct results when using castling sample data script <br> and 2008R2 but seems slow to me and can't figure out how to make it without recursive cte <br>