O, sorry I forgot to tell you that the query will truncate the decimal unless you convert. Use this:
SELECT CEILING(CONVERT(float,COUNT(Entry_ID))/60) AS PageCount FROM eSRS_BilLData WHERE Request_ID = 1 - Daniel Elmore -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ryan Everhart Sent: Tuesday, April 05, 2005 2:36 PM To: [email protected] Subject: Re: Easy Rounding TSQL Question Dan, Thanks for the reply. Still getting a value of 4 from this query.... SELECT CEILING((COUNT(Entry_ID)/60)) AS PageCount FROM eSRS_BilLData WHERE Request_ID = 1 However if I do PRINT CEILING(4.6) in query analyzer it works fine and returns 5 like I would like. Am I doing someting wrong? On Apr 5, 2005 2:28 PM, Daniel Elmore <[EMAIL PROTECTED]> wrote: > Use CEILING > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Behalf Of Ryan Everhart > Sent: Tuesday, April 05, 2005 2:25 PM > To: [email protected] > Subject: Easy Rounding TSQL Question > > The query below returns a value of 4 and I would like to get a value of 5. > > COUNT(Entry_ID) = 277 > COUNT(Entry_ID) / 60 = 4.6 > > SELECT ROUND((COUNT(Entry_ID)/60),0) AS PageCount > FROM eSRS_BilLData > WHERE Request_ID = 1 > > Can someone help me here? I thought Round would work. I need anything > over 4.0 to be displaed as 5 pages. > > Ryan > ---------------------------------------------------------- > To post, send email to [email protected] > To unsubscribe: > http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > To subscribe: > http://www.dfwcfug.org/form_MemberRegistration.cfm > > ---------------------------------------------------------- > To post, send email to [email protected] > To unsubscribe: > http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > To subscribe: > http://www.dfwcfug.org/form_MemberRegistration.cfm > > ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
