/*get section size in GBs*/
	select @section=1.01*convert(numeric(10,1),sum(iif(type_desc='ROWS',size/128./1024,0)))/4 
	from sys.master_files 
	where database_id>4
	and state_desc='ONLINE'

	;with sections
	as
	(
		select 0*@section    [min],     1*@section [max],      1     [i] 	union all
		select 1*@section+1  [min], 	2*@section [max],      2     [i]	union all
		select 2*@section+1  [min], 	3*@section [max],      3     [i]	union all
		select 3*@section+1  [min], 	4*@section [max],      4     [i]	union all
		select 4*@section+1  [min], 	5*@section [max],      5     [i]
	)
	,     data
	as
	(
		select database_id                                
		,		db_name(database_id)                        [name]
		,		convert(numeric(10,1),sum(iif(type_desc='ROWS',size/128./1024,0))) [sizeGB]
		,		SUM(convert(numeric(10,1),sum(iif(type_desc='ROWS',size/128./1024,0)))) OVER (ORDER BY newid()) [sum]
		from sys.master_files
		where database_id>4
		and state_desc='ONLINE'
		group by database_id
	)
	
	insert into dbo.dbcc_databases ( dt, name, sizeGB, n, done )
	select 
		getdate()
		,d.name
		,d.sizeGB
		,s.i [n]
		,0
	from data     d
	join sections s on d.sum between s.min and s.max

drop table if exists #rucksack5 

declare @seg numeric(10,1) /*rugsak size*/
declare @i smallint /*amount of rugsaks*/ = 10

select @seg=1.01*sum(dest_datatype_id) / @i
from msdb..MSdbms_datatype_mapping

;with segs (id, st,en) as 
(
	select top (@i) map_id [n], (map_id-1)*@seg, map_id*@seg 
	from msdb..MSdbms_datatype_mapping
	where map_id<=@i+1
)
,data as (
		select
			 map_id,
			dest_datatype_id [item_w],
			SUM(dest_datatype_id) OVER (ORDER BY map_id) [sum]
		from msdb..MSdbms_datatype_mapping
		)
select 	
		d.map_id,
		item_w,
		s.id [rug_id],
		d.[sum]
	into #rucksack5
	from data d
	join segs s on (d.sum>=s.st and d.sum<s.en)

select @seg [rugzak_size]

select 
	rug_id
	,count(1) [items]
	,sum(item_w) [items_weight]
	, sum([sum]) [ttl_size]
from #rucksack5
group by rug_id