Re: Measurement conversion

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Adam Machanic (amachanic_at_hotmail._removetoemail_.com)
Date: 08/25/04 

Date: Wed, 25 Aug 2004 17:50:18 -0400

Oops, hit send too quickly last time...

This will round up the calculation if the precision of the number of feet is
greater than 0.0009; else, it will round down... If you want to make it
round up more often, just change the 0.499:

SELECT Orderid, Bundlename, PanelID, Linenumber,
        ROUND((Height/12.0) + 0.499, 0) AS Height,
        ROUND((Length/12.0) + 0.499, 0) AS Length,
Panelstatus, CompletedDT FROM panel
WHERE completedDT BETWEEN '2004-08-25 06:00' AND '2004-08-25 17:00'
and panelstatus='C'
order by completeddt

"Steve T." <stornari@nvrinc.com> wrote in message
news:OhQVqwuiEHA.3896@TK2MSFTNGP15.phx.gbl...
> I am looking for a query that will convert inches into feet:
> Here is what I have:
>
> SELECT Orderid, Bundlename, PanelID, Linenumber, Height, Length,
> Panelstatus, CompletedDT FROM panel
> WHERE completedDT BETWEEN '2004-08-25 06:00' AND '2004-08-25 17:00'
> and panelstatus='C'
> order by completeddt
>
> The height and Lenght are returned as:
> Height Length
> 93.0 25.375
>
> I want those values returned as feet. I'm seeing that I need to apply *12
to
> a delcare statment, but not sure how to format the query.
> I do not need to display the inches, just round the total footage up.
>
> any help is appreciated.
>
>

Relevant Pages

  • Re: Conversion component Meter/Feet-Inch
    ... However, the problem remains simple and does not need a full component, especially as only you know whether or not you want to round up, round off, or truncate the result and whether you want to consider fractions of an inch or have a specific number of decimal places of accuracy. ... To convert from feet and inches to metres, simply multiply the number of feet by 12, add the number of inches, and divide the result by 39.37. ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Air Elemental Bullshit
    ... PCs were holed up in an inn, the cleric smashed the gem outside the window and the elemental appeared 20 feet up and maybe 30 feet from the mob. ... So, for example, after the second round when in spat everyone out on the ground, the survivors held an action to attack it as it came to suck them up again. ... One EL 5 monster wiping out an EL 12 encounter more or less by itself is a problem IMO. ...
    (rec.games.frp.dnd)
  • 3.5E: Listen DCs, decibels and distance
    ... feet of distance. ... rough conversion between Listen DCs and decibel sound pressure levels. ... Sound pressure drops by 6.02 dB each time the distance from the source ... round battle at Listen -10 doesn't normally risk deafening the ...
    (rec.games.frp.dnd)
  • Re: Movement on large scale battlefields
    ... increasing the scale from the default of 5 feet per square ... grid is clear-cut. ... from one round to the next. ...
    (rec.games.frp.dnd)
  • Re: Saberhagens Swords (reprise)
    ... take it from her hands, and sheath it, they could feel how a change for ... The onset of the effect, while rapid, was not instantaneous. ... effect is delayed until the next round. ... 2000 feet is kind of strong. ...
    (rec.games.frp.dnd)