USP_DATABASESPACEUSEDHISTORY_SAVE

CREATE procedure dbo.[USP_DATABASESPACEUSEDHISTORY_SAVE]
(
  @BUSINESSPROCESSSTATUSID uniqueidentifier,
  @ASOF datetimeoffset,
  @TYPECODE tinyint,
  @SUBTYPECODE tinyint
)
as begin
  set nocount on;

  insert into dbo.[DATABASESPACEUSEDHISTORY]
  (
    [BUSINESSPROCESSSTATUSID],
    [ASOF],
    [TYPECODE],
    [SUBTYPECODE],
    [ROWS],
    [RESERVEDKB],
    [DATAKB],
    [INDEXKB],
    [UNUSEDKB]
  )
  select
    @BUSINESSPROCESSSTATUSID,
    @ASOF,
    @TYPECODE,
    @SUBTYPECODE,
    isnull(sum(cast([ROWS] as bigint)), 0),
    isnull(sum(cast([RESERVEDKB] as bigint)), 0),
    isnull(sum(cast([DATAKB] as bigint)), 0),
    isnull(sum(cast([INDEXKB] as bigint)), 0),
    isnull(sum(cast([UNUSEDKB] as bigint)), 0)
  from dbo.[DATABASESPACEUSED]
  where [TYPECODE] = @TYPECODE and [SUBTYPECODE] = @SUBTYPECODE;

  return 0;
end