First i thank your reply lutzM and bitbucket.

First i want to explain my requirement clear.

The inventory table (tblInventoryStock) contains the inventory entries.

The Problem is here is, the product may...

Thank you for your reply brandie. Take this sample script and help me out to get the result same as in my prev post image.

CREATE TABLE [dbo].[tblProduct](

[i_id] [int] NOT NULL,

[vc_code]...

Hi Lowell,

thanks for your reply. I want to go all levels. but ur proc will go still Grand child level. Can u have any other idea,...

Hi,

Thanks for your reply. Can u give any code samples? That could help me to go further.

Thanks,

Hi lowell

thank you very much for your response. For example, if i have more than 5 levels means we have to recursive the above statement. Am i...

Hi Lowell,

Excellent Answer Lowell. You are 100% correct. So if after getting the hierarchy

with the SP "sp_msdependencies" i started from the last level. Consider the level is 10.

I have...

Hi Ashish,

Thanks for ur reply. But the fact is, in my db there is no cascde delete option. (i.e., we didnt used...

Hi Lowell and Alzdba,

Both guys gave to me an excellent way to built a hierarchy of tables.

Alzdba, your script includes a duplicates of record also. I dont know where...