<div>
Hi AngelIII,<br />
<br />
I am not familiar with SP, would you please add sample data to it and show result at the SP?<br />
<br />
Thank you.
</div>


Hi AngelIII,

I am not familiar with SP, would you please add sample data to it and show result at the SP?

Thank you.

<div>
Hi Sharat_123,<br />
<br />
It works.<br />
<br />
Thank you very much for your help.
</div>


Hi Sharat_123,

It works.

Thank you very much for your help.

<div>
once you created my function, you use it like this with your actual table<br />

<pre><code id="code-313356">select t.*, dbo.GetDepth(t.ItemCode) depth
  from yourtable t</code></pre>
</div>


once you created my function, you use it like this with your actual table


select t.*, dbo.GetDepth(t.ItemCode) depth
  from yourtable t

<div>
Hi AngelIII,<br />
<br />
Ok. <br />
<br />
Thank you very much for your help.
</div>


Hi AngelIII,

Ok.

Thank you very much for your help.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
ItemCode &nbsp; ItemName &nbsp; ItemGroup<br />
SFD &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Softdrink &nbsp; &nbsp;<br />
CCL &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Coca Cola &nbsp; &nbsp;SFD &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />
FNT &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Fanta &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SFD &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />
SPR &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Sprite &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SFD &nbsp; &nbsp; &nbsp; <br />
SPRZ &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Sprite &nbsp; Zero &nbsp; &nbsp; &nbsp; SPR &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />
ACL &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Alcohol<br />
TQL &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Tequila &nbsp; &nbsp; &nbsp; &nbsp;ACL<br />
VDK &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Vodka &nbsp; &nbsp; &nbsp; &nbsp; ACL<br />
<br />
I want to know a depth level for given ItemCode? &nbsp;Given SPRZ get 3.<br />
<br />
How could I do it?<br />
<br />
Thank you.
</div>
</div>


Hi,

ItemCode   ItemName   ItemGroup
SFD             Softdrink    
CCL            Coca Cola    SFD            
FNT             Fanta           SFD            
SPR             Sprite          SFD       
SPRZ             Sprite   Zero       SPR                     
ACL             Alcohol
TQL             Tequila        ACL
VDK             Vodka         ACL

I want to know a depth level for given ItemCode?  Given SPRZ get 3.

How could I do it?

Thank you.

Get Dept Level of Hierarchy of Given ItemCode.

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.