Dan, Thanks again. I figured it out. I needed to be dividing by 60.0 and not 60. The ceiling function works great!
Ryan On Apr 5, 2005 2:36 PM, Ryan Everhart <[EMAIL PROTECTED]> wrote: > 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
