Posted by Hugo Kornelis on 11/07/07 22:27

On Wed, 07 Nov 2007 06:48:09 -0800, amj1020 wrote:

>I have three fields date, low, high. I need to calculate the midpoint
>of low and high and display it.

Hi amj1020,

SELECT "date", (low + high) / 2.0 AS midpoint
FROM YourTable;

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

• Next in forum: Re: SQL 2005 32bit upgrade to 64bit possible?
• Prev in forum: SQL 2005 32bit upgrade to 64bit possible?
• Thread view: Re: How to calculate the midpoint

[Reply to this message]