|
|
|
|   |
|
|
| Last week most active authors |
| No posts for a week |
|
|
|
|
|
|
|
| |
| Last active threads |
En un an, le marché immobilier a chuté de 27%%
Started The Ghost of Kurtosis · Date: Jun 16, 2008 11:40 ·
42 post(s) |
T-SQL math is wrong
Started childofthe1980s · Date: Jun 16, 2008 11:14 ·
22 post(s) |
NVIDIA GT200 GPU and Architecture Analysis
Started NV55 · Date: Jun 16, 2008 12:06 ·
6 post(s) |
NVIDIA GT200 GPU and Architecture Analysis
Started NV55 · Date: Jun 16, 2008 12:06 ·
6 post(s) |
Causes at Facebook and MySpace for Proportional Representation-based Socialism
Started Steve Wallis · Date: Jun 16, 2008 11:08 ·
1 post(s) |
Causes at Facebook and MySpace for Proportional Representation-based Socialism
Started Steve Wallis · Date: Jun 16, 2008 11:06 ·
1 post(s) |
Variable Declaration
Started R Tanner · Date: Jun 16, 2008 09:35 ·
21 post(s) |
Formula Problem
Started suzi_wells · Date: Jun 16, 2008 08:55 ·
3 post(s) |
Annulation de mariage, jurisprudence, laicite, "qualités essentielles"
Started Johannes Baagoe · Date: Jun 13, 2008 04:56 ·
125 post(s) |
Driving rules of the road in Canada vs. US
Started techman41973 · Date: Jun 15, 2008 10:42 ·
57 post(s) |
|
| Last week hot threads |
| No posts for a week |
|
|
|
|
|
| Latest posts |
Re: En un an, le marché immobilier a chuté de 27%%
Group: fr.misc.finance · Group Profile · Search for multiply in fr.misc.finance
Author: jerome balti
Date: Jun 16, 2008 12:51
...of Kurtosis" <skewness@gmail.com> a écrit dans le message de news: 4856b3aa$0$26482$426a74cc@news.free.fr... C'est TF1 qui le dit : http://videos.tf1.fr/video/news/0,,3878622,00-promotions-multiplient-pour-attirer-clients-.html Tous les beaufs de droite sont au courant maintenant !! tiens je lis aussi "Un café moins cher pour faire revenir les clients" Dans les bars, les gérants ont enregistré une baisse de ...
Show full article (1.58Kb) |
Re: T-SQL math is wrong
Group: microsoft.public.sqlserver.programming · Group Profile · Search for multiply in microsoft.public.sqlserver.programming
Author: childofthe1980s
Date: Jun 16, 2008 12:35
... and the DUE DATE field is less than 0, then take that difference, then divide by 30 days, multiply times -1, then multiply times thed CURTRXAM field ("amount remaining" field), then multiply times the FNCHPCNT field (finance charge "percent" field of 150), and finally multiply times .01 in order to get the finance charge field to be 1.50. ...
Show full article (2.27Kb) |
Re: T-SQL math is wrong
Group: microsoft.public.sqlserver.programming · Group Profile · Search for multiply in microsoft.public.sqlserver.programming
Author: childofthe1980s
Date: Jun 16, 2008 12:21
...the dates difference by 30 will result in zero if the date difference is less than 30 days (because of integer division rules). To preserve the decimals from the division you can divide by 30.0 or multiply by 1.0 to force decimal results. Also, it seems you complicate the logic too much by trying to trim the time portion before performing DATEDIFF. This is not necessary because DATEDIFF calculates difference between ...
Show full article (1.94Kb) |
Re: T-SQL math is wrong
Group: microsoft.public.sqlserver.programming · Group Profile · Search for multiply in microsoft.public.sqlserver.programming
Author: Aaron Bertrand [SQL Server MVP]
Date: Jun 16, 2008 12:12
...the dates difference by 30 will result in zero if the date difference is less than 30 days (because of integer division rules). To preserve the decimals from the division you can divide by 30.0 or multiply by 1.0 to force decimal results. Also, it seems you complicate the logic too much by trying to trim the time portion before performing DATEDIFF. This is not necessary because DATEDIFF calculates difference between boundaries...
Show full article (1.45Kb) |
Re: NVIDIA GT200 GPU and Architecture Analysis
Group: alt.comp.hardware.amd.x8664 · Group Profile · Search for multiply in alt.comp.hardware.amd.x8664
Author: NV55
Date: Jun 16, 2008 12:11
... have to be rewritten for GT200 anyway if the application developer wants to make serious use of FP64 support.... ah, but that's comparatively slow in GT200, and heck, 16KiB for every SM is a fair aggregate chunk of SRAM when multiplied out across the whole chip. 1.4B transistors sounds like room to breathe, but we doubt NVIDIA see it as an excuse to be so blasé about on-chip SRAM pools, even if they are inherently redundant parts of the ...
Show full article (12.54Kb) |
Re: NVIDIA GT200 GPU and Architecture Analysis
Group: comp.sys.ibm.pc.hardware.video · Group Profile · Search for multiply in comp.sys.ibm.pc.hardware.video
Author: NV55
Date: Jun 16, 2008 12:11
... have to be rewritten for GT200 anyway if the application developer wants to make serious use of FP64 support.... ah, but that's comparatively slow in GT200, and heck, 16KiB for every SM is a fair aggregate chunk of SRAM when multiplied out across the whole chip. 1.4B transistors sounds like room to breathe, but we doubt NVIDIA see it as an excuse to be so blasé about on-chip SRAM pools, even if they are inherently redundant parts of the ...
Show full article (12.54Kb) |
Re: T-SQL math is wrong
Group: microsoft.public.sqlserver.programming · Group Profile · Search for multiply in microsoft.public.sqlserver.programming
Author: Michael Ware
Date: Jun 16, 2008 12:11
...s date and the DUE DATE field is less than 0, then take that difference, then divide by 30 days, multiply times -1, then multiply times thed CURTRXAM field ("amount remaining" field), then multiply times the FNCHPCNT field (finance charge "percent" field of 150), and finally multiply times .01 in order to get the finance charge field to be 1.50. Again, ...
Show full article (1.78Kb) |
Re: T-SQL math is wrong
Group: microsoft.public.sqlserver.programming · Group Profile · Search for multiply in microsoft.public.sqlserver.programming
Author: childofthe1980s
Date: Jun 16, 2008 12:06
...the dates difference by 30 will result in zero if the date difference is less than 30 days (because of integer division rules). To preserve the decimals from the division you can divide by 30.0 or multiply by 1.0 to force decimal results. Also, it seems you complicate the logic too much by trying to trim the time portion before performing DATEDIFF. This is not necessary because DATEDIFF calculates difference between boundaries...
Show full article (1.09Kb) |
Re: En un an, le marché immobilier a chuté de 27%%
Group: fr.misc.finance · Group Profile · Search for multiply in fr.misc.finance
Author: finesse
Date: Jun 16, 2008 12:01
... Ghost of Kurtosis" <skewness@gmail.com> a Ă©crit dans le message de news: 4856b3aa$0$26482$426a74cc@news.free.fr... C'est TF1 qui le dit : http://videos.tf1.fr/video/news/0,,3878622,00-promotions-multiplient-pour-attirer-clients-.html Tous les beaufs de droite sont au courant maintenant !! Autre article (pour les profs de gauche) : http://hebdo.nouvelobs.com/hebdo/obs/p2275/articles/a376982-.html 1. La baisse ...
Show full article (1.86Kb) |
Re: T-SQL math is wrong
Group: microsoft.public.sqlserver.programming · Group Profile · Search for multiply in microsoft.public.sqlserver.programming
Author: Alex Kuznetsov
Date: Jun 16, 2008 11:51
... DIFFERENCE], [AMOUNT REMAINING], [FINANCE CHARGE MULTIPLIER], [FINANCE CHARGE] FROM ( select RM20101.... FNCHPCNT*.01 AS [FINANCE CHARGE MULTIPLIER], CASE WHEN datediff(day,convert(... DIFFERENCE], [AMOUNT REMAINING], [FINANCE CHARGE MULTIPLIER], [FINANCE CHARGE] "Aaron Bertrand [SQL ... field ("amount remaining" field), then multiply times the FNCHPCNT field (finance...field of 150), and finally multiply times .01 in order to...
Show full article (3.42Kb) |
|
|
|
