Sir, I need your help in the following Topic.
1) What is meant by hierarchical Query?
2) In which cases, we need this query?
3) what is the benefit of using this?
Please note that do not reply with any web link reference. I need only the answer for my questions.
Loading
Jignesh TrivediPosted Oct 11, 2013, 9:52 AM
hi,
Hierarchical Query, that handle hierarchical model data, we can say more general recursive fixpoint.....
CTE (common table expression may help us to implement Hierarchical Query
CTE is a temporary result set and it is similar to derived table. it is not stored object it is more readable than a derived table...
read my article to know more about CTE
http://www.c-sharpcorner.com/UploadFile/ff2f08/common-table-expression-cte-in-sql-server/
hope this will help you.