javascript - Stored Procedure for finding N Level Child List -

javascript - Stored Procedure for finding N Level Child List -

recently came across 1 problem of finding n level kid tables.

let have next list of tables:

table: **country** pkcountryid countrycode countryname table: **state** pkstateid fkcountryid statecode statename table: **area** pkareaid fkstateid areacode areaname table: **customer** pkcustomerid fkareaid customercode customername , on....

here need find way can n level treeview columns

just

>country country table column foreign key column of country table(here : fkstateid) >state state table column foreign key column of state table

and on till n level.

is there solution?

you can create hierarchy using cte. if build hte cte properly, load many levels need. however, i've built these before , must careful in writing code , how write or else performance may suffer.

do seek utilize cte grab info , determine if fit need.

javascript sql-server asp.net-mvc