Advertisement
Advertisement
| 05.29.2008 at 09:51AM PDT, ID: 23442097 |
|
[x]
Attachment Details
|
||
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: |
select t.LeaderLap, Hours=case when (passingtime*.0001)/3600 < 10 then '0' + cast(floor((passingtime*.0001)/3600) as varchar) else cast(floor((passingtime*.0001)/3600) as varchar) end, Minutes=case when (floor(((passingtime*.0001)-((floor((passingtime*.0001)/3600))*3600))/60)) <10 then '0' + cast((floor(((passingtime*.0001)-((floor((passingtime*.0001)/3600))*3600))/60))as varchar) else cast((floor(((passingtime*.0001)-((floor((passingtime*.0001)/3600))*3600))/60))as varchar) end, Seconds=case when ((passingtime*.0001)-((floor((passingtime*.0001)/3600.0000))*3600.0000)-((floor(((passingtime*.0001)-((floor((passingtime*.0001)/3600.0000))*3600.0000))/60.0000))*60.0000))<10 then '0' + cast(((passingtime*.0001)-((floor((passingtime*.0001)/3600.0000))*3600.0000)-((floor(((passingtime*.0001)-((floor((passingtime*.0001)/3600.0000))*3600.0000))/60.0000))*60.0000))as varchar) else cast(((passingtime*.0001)-((floor((passingtime*.0001)/3600.0000))*3600.0000)-((floor(((passingtime*.0001)-((floor((passingtime*.0001)/3600.0000))*3600.0000))/60.0000))*60.0000))as varchar) end, SecondsTrimed=TRIM(Seconds '.') FROM passings t Where leaderlap>=0 AND decoderid=100 AND deleted=0 AND RunID = (SELECT RunID FROM Runs WHERE Preamble = 'R.I') and t.PassingID = ( select min(i.passingid) from passings i where i.leaderLap = t.LeaderLap) Order By t.LeaderLap asc |