.

Hey jeff,

i am inspired with your words, i strongly agree with you that we have to write very optimised queries then trying for loops which consumes more processor time in batch...

Thank you jeff.

Your solution is better and useful then mine, i wrote it by referring to a book

Thank you friends, I found the solution

I need to make a temp_table for product information table.

declare @value int,@min int

declare @return varchar(300),

@name varchar(300)

set @return=''

select @value=max(id) from product_information

select @min-2=min(id) from product_information

        WHILE...

Jeff,

my sample table already has data, how can i union all now? without creating new table and inserting each tuple with union all???

Peter,

Select currentcategory.CategoryID, currentcategory.CategoryName, childitem.CategoryID, childitem.CategoryName

from Categories currentcategory inner join Categories childitem

on currentcategory.CategoryID = childitem.ParentcategoryID 

with the above query i can retrive all parents, children and childrens children... how can i...

I have tried the function you posted. The UDF you posted in this question and my previous question are working in the opposite way of my expectation that too with the table...

Hi Peter,

I want to retrieve all the children and childrens children... of a given category including parent. assume that if i want to find category 10's sub and sub sub categories...

Peter, is there a possible way to make this function work with a table which tuples are not unioned? or could u plz tell me how can i union all the...

Peter how to union all existing tuples in the table as in your previous solution you inserted each tuple by union all, how can we union all the existing tuples in the...

ya i saw this code...it returns more then just a depth

yeap, i saw peter's previous code for function and it is really helpful for me for finding depth, i dont find any other values it returns otherthen level/depth.

peter my previous question was about finding the depth, now i am with different question.

Peter, it works, Thank you.

buddy i was out of town and couldnt reply to your post

peter,  your solution sounds good, i tried it but it returns the output NULL for all levels, can u...