hi there
i dont think there is a way to find out that result in a single query, but u can make a recursive stored procedure for that and passing an ID to that sp and in that sp u will declare a cursor for those records which have their parent category as that passed ID and then insert those IDs...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.