USP_DATABASESPACEUSED_TOPNDATA

CREATE procedure dbo.[USP_DATABASESPACEUSED_TOPNDATA]
(
  @MAXROWS integer = 20,
  @ORDERBY tinyint = 0
)
as begin
  set nocount on;

  select top (@MAXROWS)
    [DATABASESPACEUSED].[NAME],
    isnull([RECORDTYPE].[NAME], '') as [RECORDTYPENAME],
    [DATABASESPACEUSED].[ROWS],
    [DATABASESPACEUSED].[RESERVEDKB],
    [DATABASESPACEUSED].[DATAKB],
    [DATABASESPACEUSED].[INDEXKB],
    [DATABASESPACEUSED].[UNUSEDKB],
    [DATABASESPACEUSED].[TABLECATALOGID],
    [RECORDTYPE].[ID] as [RECORDTYPEID]
  from dbo.[DATABASESPACEUSED]
  left outer join dbo.[RECORDTYPE] on [RECORDTYPE].[BASETABLENAME] = [DATABASESPACEUSED].[NAME]
  where [DATABASESPACEUSED].[TYPECODE] = 1
  order by case @ORDERBY when 0 then [RESERVEDKB] when 1 then [DATAKB] when 2 then [INDEXKB] when 3 then [UNUSEDKB] end desc;

  return 0;
end