pagination in Hierarchy

Bahawalpur Azadari Network answered on February 13, 2024 Popularity 1/10 Helpfulness 1/10

answer pagination in Hierarchy

pagination in Hierarchy

Comment

;WITH children AS
(
    SELECT Item, Parent 
    FROM #TempHeirarchy 
    UNION ALL
    SELECT e.Item, e.Parent  
    FROM #TempHeirarchy e 
    INNER JOIN children e2 
       ON e.Parent = e2.Item
)
select * into #TempFinal
from (select row_number() over(order by parent asc) as RowNumber, * from children) t
where t.RowNumber between 1 and 10

Popularity 1/10 Helpfulness 1/10 Language whatever

Source: stackoverflow.com

Tags: hierarchy pagination whatever

Link to this answer
Share Copy Link

Contributed on Feb 13 2024

Bahawalpur Azadari Network

0 Answers Avg Quality 2/10

pagination in Hierarchy

Contents

More Related Answers

pagination in Hierarchy

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.