Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How-To create a query that returns percentage
Message
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
How-To create a query that returns percentage
Divers
Thread ID:
00634230
Message ID:
00634230
Vues:
46
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?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform