USP_DATABASESPACEUSED_TOPNOTHER

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

  select top (@MAXROWS)
    [DATABASESPACEUSED].[SCHEMANAME],
    [DATABASESPACEUSED].[NAME],
    [DATABASESPACEUSED].[ROWS],
    [DATABASESPACEUSED].[RESERVEDKB],
    [DATABASESPACEUSED].[DATAKB],
    [DATABASESPACEUSED].[INDEXKB],
    [DATABASESPACEUSED].[UNUSEDKB],
    [TABLECATALOG].[ID] as [TABLECATALOGID],
    [RECORDTYPE].[ID] as [RECORDTYPEID]
  from dbo.[DATABASESPACEUSED]
  left outer join dbo.[TABLECATALOG] on [TABLECATALOG].[TABLENAME] = [DATABASESPACEUSED].[NAME]
  left outer join dbo.[RECORDTYPE] on [RECORDTYPE].[BASETABLENAME] = [DATABASESPACEUSED].[NAME]
  where [DATABASESPACEUSED].[TYPECODE] = 0
  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