USP_SIMPLEDATALIST_KPIINSTANCEFOLDERS

Parameters

Parameter Parameter Type Mode Description
@CURRENTAPPUSERID uniqueidentifier IN

Definition

Copy


create procedure dbo.[USP_SIMPLEDATALIST_KPIINSTANCEFOLDERS]
(
    @CURRENTAPPUSERID uniqueidentifier
)
as
    set nocount on;

    select
        [ID] as [VALUE],
        [NAME] as [LABEL],
        [PARENTFOLDERID] as [DESCRIPTION]
    from dbo.[KPIINSTANCEFOLDER]
    order by [DISPLAYORDER]