USP_SIMPLEDATALIST_BUSINESSPROCESSESFROMDATABASESPACEUSED

create procedure dbo.[USP_SIMPLEDATALIST_BUSINESSPROCESSESFROMDATABASESPACEUSED]
as begin
  set nocount on;

  select distinct
    [BUSINESSPROCESSCATALOG].[ID] as [VALUE],
    [BUSINESSPROCESSCATALOG].[NAME] as [LABEL]
  from [DATABASESPACEUSED]
  inner join dbo.[BUSINESSPROCESSOUTPUT] on [BUSINESSPROCESSOUTPUT].[ID] = [DATABASESPACEUSED].[BUSINESSPROCESSOUTPUTID]
  inner join dbo.[BUSINESSPROCESSSTATUS] on [BUSINESSPROCESSSTATUS].[ID] = [BUSINESSPROCESSOUTPUT].[BUSINESSPROCESSSTATUSID]
  inner join dbo.[BUSINESSPROCESSCATALOG] on [BUSINESSPROCESSCATALOG].[ID] = [BUSINESSPROCESSSTATUS].[BUSINESSPROCESSCATALOGID]
  order by [BUSINESSPROCESSCATALOG].[NAME];

  return 0;
end