UFN_GLACCOUNTSEQUENCE

CREATE function dbo.UFN_GLACCOUNTSEQUENCE()
returns table
            as return
select 
              TOP 30 ID, 
                    NAME,
          Length,
                    SEGMENTSEQUENCE

                from 
                    dbo.ACCOUNTSTRUCTURE
          where elementtypecode = 1
          ORDER BY SEGMENTSEQUENCE