USP_DATALIST_NIMBUSKPIINSTANCERESOURCE

CREATE procedure dbo.USP_DATALIST_NIMBUSKPIINSTANCERESOURCE(@RECORDTYPEID uniqueidentifier = null)
as
    select KPIINSTANCE.ID,
        KPIINSTANCE.NAME,
        KPIINSTANCE.DESCRIPTION,
        CHANGEAGENT.USERNAME AUTHOR,
        KPIINSTANCE.DATEADDED,
        KPIINSTANCE.DATECHANGED,
        KPICATALOG.NAME KPITYPE
    from dbo.KPIINSTANCE
    left join dbo.KPICATALOG on KPIINSTANCE.KPICATALOGID = KPICATALOG.ID
    left join dbo.CHANGEAGENT on KPIINSTANCE.ADDEDBYID = CHANGEAGENT.ID
    where (@RECORDTYPEID is null and KPICATALOG.CONTEXTRECORDTYPEID is null) or KPICATALOG.CONTEXTRECORDTYPEID = @RECORDTYPEID
    order by KPIINSTANCE.NAME;