Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How-To create a query that returns percentage
Message
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
How-To create a query that returns percentage
Miscellaneous
Thread ID:
00634230
Message ID:
00634230
Views:
45
Current Statement:
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.schedto
This returns:
RoomID   SchedFrom  SchedTo  AvailMin  UsedMins   laPercent
  1         700       1700     600       585         0
I want the laPercent to be a percentage in this case .975

Anybody have an idea?
Next
Reply
Map
View

Click here to load this message in the networking platform