select distinct
	DatabaseID, ServerName,
	DatabaseName, PhysicalFileName, DatabaseFileID,
	round(percentile_cont(0) within group (order by AvgReadStallms) 
		over (partition by PhysicalFileName),2) as ReadStallms00,
	round(percentile_cont(0.25) within group (order by AvgReadStallms) 
		over (partition by PhysicalFileName),2) as ReadStallms25,
	round(percentile_cont(0.5) within group (order by AvgReadStallms) 
		over (partition by PhysicalFileName),2) as ReadStallms50,
	round(percentile_cont(0.75) within group (order by AvgReadStallms) 
		over (partition by PhysicalFileName),2) as ReadStallms75,
	round(percentile_cont(0.9) within group (order by AvgReadStallms) 
		over (partition by PhysicalFileName),2) as ReadStallms90,
	round(percentile_cont(0.95) within group (order by AvgReadStallms) 
		over (partition by PhysicalFileName),2) as ReadStallms95,
	round(percentile_cont(0.96) within group (order by AvgReadStallms) 
		over (partition by PhysicalFileName),2) as ReadStallms96,
	round(percentile_cont(0.97) within group (order by AvgReadStallms) 
		over (partition by PhysicalFileName),2) as ReadStallms97,
	round(percentile_cont(0.98) within group (order by AvgReadStallms) 
		over (partition by PhysicalFileName),2) as ReadStallms98,
	round(percentile_cont(0.99) within group (order by AvgReadStallms) 
		over (partition by PhysicalFileName),2) as ReadStallms99,
	round(percentile_cont(0.999) within group (order by AvgReadStallms) 
		over (partition by PhysicalFileName),2) as ReadStallms99d9,
	round(percentile_cont(1) within group (order by AvgReadStallms) 
		over (partition by PhysicalFileName),2) as ReadStallms100,
	round(percentile_cont(0) within group (order by AvgWriteStallms) 
		over (partition by PhysicalFileName),2) as WriteStallms00,
	round(percentile_cont(0.25) within group (order by AvgWriteStallms) 
		over (partition by PhysicalFileName),2) as WriteStallms25,
	round(percentile_cont(0.5) within group (order by AvgWriteStallms) 
		over (partition by PhysicalFileName),2) as WriteStallms50,
	round(percentile_cont(0.75) within group (order by AvgWriteStallms) 
		over (partition by PhysicalFileName),2) as WriteStallms75,
	round(percentile_cont(0.9) within group (order by AvgWriteStallms) 
		over (partition by PhysicalFileName),2) as WriteStallms90,
	round(percentile_cont(0.95) within group (order by AvgWriteStallms) 
		over (partition by PhysicalFileName),2) as WriteStallms95,
	round(percentile_cont(0.96) within group (order by AvgWriteStallms) 
		over (partition by PhysicalFileName),2) as WriteStallms96,
	round(percentile_cont(0.97) within group (order by AvgWriteStallms) 
		over (partition by PhysicalFileName),2) as WriteStallms97,
	round(percentile_cont(0.98) within group (order by AvgWriteStallms) 
		over (partition by PhysicalFileName),2) as WriteStallms98,
	round(percentile_cont(0.99) within group (order by AvgWriteStallms) 
		over (partition by PhysicalFileName),2) as WriteStallms99,
	round(percentile_cont(0.999) within group (order by AvgWriteStallms) 
		over (partition by PhysicalFileName),2) as WriteStallms99d9,
	round(percentile_cont(1) within group (order by AvgWriteStallms) 
		over (partition by PhysicalFileName),2) as WriteStallms100
from
	dbo.DiskStall
order by 
	DatabaseName, DatabaseFileID