USP_BUSINESSPROCESS_TOPNCATALOG

create procedure dbo.[USP_BUSINESSPROCESS_TOPNCATALOG]
(
    @MAXROWS integer = 20
)
as begin
    set nocount on;

    select top (@MAXROWS)
        [BUSINESSPROCESSSTATUS].[BUSINESSPROCESSCATALOGID],
        [BUSINESSPROCESSCATALOG].[NAME],
        count(distinct [BUSINESSPROCESSSTATUS].[ID]) as [TIMESRUN],
        max([BUSINESSPROCESSSTATUS].[ENDEDON]) as [ENDEDON]
    from dbo.[BUSINESSPROCESSSTATUS]
    inner join dbo.[BUSINESSPROCESSCATALOG] on [BUSINESSPROCESSCATALOG].[ID] = [BUSINESSPROCESSSTATUS].[BUSINESSPROCESSCATALOGID]
    group by [BUSINESSPROCESSSTATUS].[BUSINESSPROCESSCATALOGID], [BUSINESSPROCESSCATALOG].[NAME] 
    order by [TIMESRUN] desc;

    return 0;
end