CASE
  WHEN DATEDIFF(SECOND,dr.startTime,dr.endTime) = 0 
  THEN 0
  ELSE ISNULL(round((hs.fractionalPart*(dr.LostGeneration/ ( DATEDIFF(SECOND,dr.startTime,dr.endTime) / 3600.0))),1),0.0)
END

DECLARE @LG AS INT
SET @LG = 1

;WITH TALLY AS (

	SELECT ROW_NUMBER() OVER(ORDER BY MSV.number) AS N
	FROM master.dbo.spt_values AS MSV
		CROSS APPLY master.dbo.spt_values AS SV2
	WHERE MSV.number < 2250
		AND MSV.number > 0
)
SELECT N
FROM TALLY
WHERE N < 3601
	AND @LG / N / 3600.0 = 0

ROUND((hs.fractionalPart * (CAST(dr.LostGeneration AS float)/
	(ISNULL(NULLIF(DATEDIFF(SECOND,dr.startTime,dr.endTime),0),1.)/3600.))),1)