USP_KPIINSTANCE_GETMETADATA

CREATE procedure dbo.USP_KPIINSTANCE_GETMETADATA(@ID uniqueidentifier)
as
    set nocount on;

    select KPIINSTANCE.KPICATALOGID,
        KPIINSTANCE.NAME,
        KPIINSTANCE.DESCRIPTION,
        KPIINSTANCE.GOALVALUE,
        KPIINSTANCE.GOALINDICATORTYPECODE,
        KPIINSTANCE.GOALAIMTYPECODE,
        KPIINSTANCE.GOALUPWARDLOWVALUE,
        KPIINSTANCE.GOALUPWARDMIDVALUE,
        KPIINSTANCE.GOALDOWNWARDMIDVALUE,
        KPIINSTANCE.GOALDOWNWARDHIGHVALUE,
        KPIINSTANCE.PARAMETERSXML,
        KPICATALOG.GOALTYPECODE,
        KPICATALOG.GOALRETRIEVALTYPECODE,
        KPIINSTANCE.HISTORYTYPECODE,
        KPIINSTANCE.NUMBEROFITEMSTOSTORE,
        KPIINSTANCE.ADDEDBYID,
        KPIINSTANCE.CHANGEDBYID,
        KPIINSTANCE.DATEADDED,
        KPIINSTANCE.DATECHANGED,
        ADDEDBY.USERNAME ADDEDBYUSERNAME,
        CHANGEDBY.USERNAME CHANGEDBYUSERNAME,
        cast(coalesce(SPECXML.value
                (
                    'declare namespace bbkpi="bb_appfx_kpi";
                    /bbkpi:KpiSpec[1]                    
                    /@UseTimePrecision','bit'
                ), 0) as bit) USETIMEPRECISION,
        KPIINSTANCE.SITEFILTERENABLEDFORINSTANCE,
        dbo.UFN_KPIINSTANCESITES_GET_TOITEMLISTXML(KPIINSTANCE.ID) as SITESSELECTED,
    KPIINSTANCE.STATUSCHANGEDALERTID,
    KPIINSTANCE.FOLDERID


    from dbo.KPIINSTANCE
    inner join dbo.KPICATALOG on KPIINSTANCE.KPICATALOGID = KPICATALOG.ID
    left join dbo.CHANGEAGENT ADDEDBY on KPIINSTANCE.ADDEDBYID = ADDEDBY.ID
    left join dbo.CHANGEAGENT CHANGEDBY on KPIINSTANCE.CHANGEDBYID = CHANGEDBY.ID
    where KPIINSTANCE.ID = @ID;