[mssms] Help on a query - formatting numbers

Wed, 21 May 2014 09:01:19 -0700 

Hello All,

I'm not much of a SQL guy and there are some SQL gurus here so I'm reaching
out for some help on a query that I would like to use for a report.

In the query below (CL.EvaluationLength/60 'Length') is integer type and
comes back as '380339'/60 = 6339 with 6 being minutes and the 339 are
seconds. I would like to format the output as '6.339' for the report but
having trouble getting the right function to do it so any help would be
appreciated.

Also, if some has already created a report to show how long collections are
taking to evaluate and would like to share it would be great.


SELECT cg.SiteID 'Collection ID'
  ,cg.CollectionName 'Collection Name'
      ,CL.EvaluationLength 'Eval Length'
  ,CL.EvaluationLength/60 'Length'
  ,cg.Schedule
      ,EvaluationStartTime
      ,LastRefreshTime
      ,MemberChanges
  FROM Collections_L CL
  inner join Collections_G CG on cl.CollectionID = cg.CollectionID
  order by CL.EvaluationLength desc

Thanks,
Cesar

Reply via email to