USP_SIMPLEDATALIST_KPICATEGORIES

create procedure dbo.USP_SIMPLEDATALIST_KPICATEGORIES
as
    set nocount on;

    select
        KPICATEGORY.CATEGORY VALUE,
        KPICATEGORY.CATEGORY LABEL
    from(
        select distinct 
            case CHARINDEX('\',KPICATALOG.UIFOLDER,1)
                when 0
                    then KPICATALOG.UIFOLDER
                else SUBSTRING(KPICATALOG.UIFOLDER,1,CHARINDEX('\',KPICATALOG.UIFOLDER,1) - 1) 
            end CATEGORY
        from dbo.KPICATALOG
    ) KPICATEGORY
    order by KPICATEGORY.CATEGORY