UFN_PDCONSTITUENCYORDER

Returns constituency hierarchal order

Return

Return Type
table

Definition

Copy



create function dbo.UFN_PDCONSTITUENCYORDER()
returns table
as
  return
    select top 100 percent V_CONSTITUENCY.ID, row_number() over (order by isnull(PDCONSTITUENCYORDER.SEQUENCE,9999), DESCRIPTION) as SEQUENCE, V_CONSTITUENCY.DESCRIPTION
    from dbo.V_CONSTITUENCY left join dbo.PDCONSTITUENCYORDER on V_CONSTITUENCY.ID = PDCONSTITUENCYORDER.CONSTITUENCYCODEID
    order by SEQUENCE