Re: Basic SQL debugging

2008-01-28 Thread Huebschman, George J.
Andrew, Thanks. That fixed the issue. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Raibeck Sent: Saturday, January 26, 2008 10:43 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Basic SQL debugging You are on the right track. A couple

Re: Basic SQL debugging

2008-01-26 Thread Andrew Raibeck
You are on the right track. A couple of things to consider: - The values you are operating on are integral values, so you get integral results. In order to get fractional parts, you need to force the math to floating point mode. This can be done by bringing an otherwise ineffective floating point