USP_DATALIST_PDCONSTITUENCYORDER

  CREATE procedure dbo.USP_DATALIST_PDCONSTITUENCYORDER
  as
    set nocount on;

  select PDCONSTITUENCYORDER.ID, DESCRIPTION
  from dbo.V_CONSTITUENCY left join dbo.PDCONSTITUENCYORDER on V_CONSTITUENCY.ID = PDCONSTITUENCYORDER.CONSTITUENCYCODEID
  order by isnull(PDCONSTITUENCYORDER.SEQUENCE,9999), DESCRIPTION