further reading here may give you some ideas
http://www.sqlservercentral.com/articles/Hierarchy/94040/
http://www.sqlservercentral.com/articles/T-SQL/94570/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day