Yes! that did it. thank you!
On Wed, May 21, 2014 at 1:53 PM, Eggen, Casey <[email protected]>wrote: > Try > > > > left (CL.EvaluationLength/60.0/1000,4) > > > > I am fairly certain that’s the right formula. > > > > > > *Casey Eggen* > > > > *From:* [email protected] [mailto: > [email protected]] *On Behalf Of *elsalvoz > *Sent:* Wednesday, May 21, 2014 3:33 PM > *To:* [email protected] > *Subject:* Re: [mssms] Help on a query - formatting numbers > > > > Yes and thank you. That's formatting the numbers the number correctly as I > was hoping '0.000000', it returns more numbers that I was expecting but is > not an issue. > > One other thing I was wondering is if I'm doing the calculation correctly. > +++++++++++++++++++++++++++++++++++ > DB returns + calculated (col_2/60.0/1000) > +++++++++++++++++++++++++++++++++++ > *Eval Length + Length + > +++++++++++++++++++++++++++++++++++ > *380393 + 6.33988333300 + > +++++++++++++++++++++++++++++++++++ > 380 Secs + > 393 milsec + > > If I am understanding the question right, you should be able to enter the > following for a (minutes. Seconds) format > > > > (CL.EvaluationLength/60.0/1000 'Length') > > > > *Casey Eggen* > > *Network Services* > > Phone 573-634-5600 ext. 6423 > > Cell 573-619-4556 > > > > *From:* [email protected] [mailto: > [email protected]] *On Behalf Of *elsalvoz > *Sent:* Wednesday, May 21, 2014 10:57 AM > *To:* [email protected] > *Subject:* [mssms] Help on a query - formatting numbers > > > > 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 > > > > > ************************************************************************************************** > Note: > The information contained in this message may be privileged and > confidential and > protected from disclosure. If the reader of this message is not the > intended > recipient, or an employee or agent responsible for delivering this message > to > the intended recipient, you are hereby notified that any dissemination, > distribution or copying of this communication is strictly prohibited. If > you > have received this communication in error, please notify us immediately > by > replying to the message and deleting it from your computer. > > ************************************************************************************************** > > > > > > > ************************************************************************************************** > Note: > The information contained in this message may be privileged and > confidential and > protected from disclosure. If the reader of this message is not the > intended > recipient, or an employee or agent responsible for delivering this message > to > the intended recipient, you are hereby notified that any dissemination, > distribution or copying of this communication is strictly prohibited. If > you > have received this communication in error, please notify us immediately > by > replying to the message and deleting it from your computer. > > ************************************************************************************************** > >
