if you can execute T-SQL SELECT statement this can be done much more easily using self join.