Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Power() usage?
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
Divers
Thread ID:
00561544
Message ID:
00561591
Vues:
26
POWER() function return type is the same as it's first parameter
SELECT 2 * cast ( POWER(<b>10.000</b>, -2) as dec(9,3) ) as total
>I am normalizing FoxPro data for a DW. I have 2 columns a
>value and an exponent. In the DW I need to create the
>real #.
>
>SELECT 2 * cast ( POWER(10, -2) as dec(9,3) ) as total
>GO
>
>
>returns .000
>
>The # 2 is my value and the -2 is my exponent.
>
>How do I get a .02 or .020 as a return?
>
>__Stephen
>.
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform