USP_SIMPLEDATALIST_PROPERTY

CREATE procedure dbo.USP_SIMPLEDATALIST_PROPERTY as
  select VALUE, LABEL
  from
    (select 
        ID as VALUE, 
        DESCRIPTION as LABEL,
    SEQUENCE
    from dbo.PROPERTYSUBTYPECODE
  union all
  select '99999999-9999-9999-9999-999999999999', 'All property subtypes', 0) V1
    order by SEQUENCE