declare @ttStart datetime declare @ttEnd datetime set @ttStart= '03/20/2002 07:00' set @ttEnd = '03/20/2002 17:00' SELECT dbo.corooms.roomid, dbo.corooms.schedfrom, dbo.corooms.schedto, (dbo.corooms.schedto - dbo.corooms.schedfrom) / 100 * 60 AS AvailMin, SUM(DATEDIFF(mi, dbo.meetings.begintime, dbo.meetings.endtime)) AS UsedMins, (SUM(DATEDIFF(mi, dbo.meetings.begintime, dbo.meetings.endtime))/((dbo.corooms.schedto - dbo.corooms.schedfrom) / 100 * 60)*100) as laPercent FROM dbo.corooms INNER JOIN dbo.meetings ON dbo.corooms.roomid = dbo.meetings.roomid WHERE (dbo.corooms.roomid = 1) AND meetings.begintime between @ttStart and @ttEnd GROUP BY dbo.corooms.roomid, dbo.corooms.schedfrom, dbo.corooms.schedtoThis returns:
RoomID SchedFrom SchedTo AvailMin UsedMins laPercent 1 700 1700 600 585 0I want the laPercent to be a percentage in this case .975