DECLARE @TimeStart DATETIME
DECLARE @Time DATETIME
DECLARE @TimeEnd DATETIME
Declare @TotalTime int
DECLARE @Count INT
Declare @TotalCount int
Declare @HighCount int
Declare @LowCount int
Declare @HighTime int
Declare @LowTime int
Declare @IterTime int
Declare @OddTime int
DECLARE @I INT
Declare @TestStart datetime
Declare @TestEnd dateTime
SET @I = 0
Set @TotalTime = 0
Set @TotalCount = 0
Set @HighCount = 0
Set @LowCount = 99999999
Set @HighTime = 0
Set @LowTime =  99999999
Set @IterTime = 0
Set @OddTime = 0
Set @TestStart = GETDATE()

WHILE @I < 10000
BEGIN

	SET @TimeStart = GETDATE()
	SET @TimeEnd = @TimeStart
	Set @Count = 0	
	-- Find the amount of time it takes to get a different value
	-- To get strictly time, comment out the Set @Count line
	WHILE @TimeStart = @TimeEnd
	BEGIN
		SET @TimeEnd = GETDATE()
		Set @Count = @Count + 1
	End
	
	Set @IterTime = DATEDIFF(MILLISECOND, @TimeStart, @TimeEnd)
	Set @TotalTime = @TotalTime + @IterTime	
	Set @TotalCount = @TotalCount + @Count
	Set @I = @I + 1
	If @Count < @LowCount
		Set @LowCount = @Count	
	If @Count > @HighCount
		Set @HighCount = @Count
	If @IterTime < @LowTime
		Set @LowTime = @IterTime
	If @IterTime > @HighTime
		Set @HighTime = @IterTime
-- Why 3? Because I ran the inner loop 100 times while building this and it was nearly always returning 3
-- 
	If @IterTime <> 3
		Set @OddTime = @OddTime + 1		
End

Set @TestEnd = GETDATE()

Print 'Test Duration'

print DATEDIFF(MILLISECOND, @teststart, @testend) / 1000
print '---------------------------'
print 'Average Iterations' 
print @TotalCount / @I
print 'High Iterations'
print @HighCount
print 'Low Iterations'
print @LowCount
print '-----------------------'
print 'Average Time'
print @TotalTime / @I
print 'High Time'
print @HighTime
print 'Low Time'
print @LowTime
print 'Odd Time Count'
print @OddTime

DECLARE @TimeStart DATETIME2
DECLARE @TimeEnd DATETIME2
DECLARE @Count INT
Declare @Duration int
DECLARE @I INT

Declare @results table(Duration int, Iterations int, StartTime datetime2, EndTime datetime2)

SET @I = 0
Set @Duration = 0

WHILE @I < 10000
BEGIN

	SET @TimeStart = sysdatetime()
	SET @TimeEnd = @TimeStart
	Set @Count = 0	
	-- Find the amount of time it takes to get a different value
	-- To get strictly time, comment out the Set @Count line
	WHILE @TimeStart = @TimeEnd
	BEGIN
		SET @TimeEnd = sysdatetime()
		Set @Count = @Count + 1
	End
	
	Set @Duration = DATEDIFF(MICROSECOND, @TimeStart, @TimeEnd)
	
	Set @I = @I + 1
		
	Insert into @results(Duration, Iterations, StartTime, EndTime)		
	values (@Duration, @Count, @TimeStart, @TimeEnd)
		
End

select Duration
	, Iterations
	, StartTime
	, EndTime 
from @results

Select AVG(duration)
From @results

select Duration
	, count(Duration)
from @results
group by Duration