USP_SIMPLEDATALIST_FAFNFGLEVELHIERARCHY

CREATE procedure dbo.USP_SIMPLEDATALIST_FAFNFGLEVELHIERARCHY
(
  @NFGCAMPAIGNID as uniqueidentifier,
  @INCLUDEROOTLEVEL as bit=0
)
as
    select 
        ID as VALUE, 
        REPLICATE(N'?', HIERARCHYPATH.GetLevel() - 1) + NAME as LABEL
    from dbo.FAFNFGCAMPAIGNLEVEL
  where NFGCAMPAIGNID = @NFGCAMPAIGNID
  and (@INCLUDEROOTLEVEL=1 or (HIERARCHYPATH.GetLevel()) > 1)
    order by HIERARCHYPATH