OK Corral - Page 48

blindman · #**706** (**permalink**) 11-29-12, 11:24

My "WTF?" of the day:

Code:

cast('1.0' as decimal(10,2)) * cast(FSEOBPercent as decimal(10,2))

...cause if you're going to multiply a value by 1, you want to make sure you do it right.

MCrowley · #**707** (**permalink**) 11-29-12, 11:30

That's why I never go back through my old code.

blindman · #**708** (**permalink**) 11-29-12, 12:44

Wait, this is YOUR code????
Damn you. All this time I'd been thinking that Pat was sneaking NZDFs into our application.

Thrasymachus · #**709** (**permalink**) 11-29-12, 13:04

I have been looking at this pile of wrongheaded dislexic short sighted tripe for so long I forgot what databases are supposed to look like. I know what not to do however.

Pat Phelan · #**710** (**permalink**) 11-29-12, 14:14

Quote:

Originally Posted by blindman

Wait, this is YOUR code????
Damn you. All this time I'd been thinking that Pat was sneaking NZDFs into our application.

I simply MUST make note of this for future use!

-PatP

MCrowley · #**711** (**permalink**) 11-29-12, 14:20

Pat would have done something like

Code:

log (exp(1)) * cast(FSEOBPercent as decimal(10,2))

Pat Phelan · #**712** (**permalink**) 11-29-12, 16:54

Quote:

Originally Posted by MCrowley

Pat would have done something like

Code:

log (exp(1)) * cast(FSEOBPercent as decimal(10,2))

Nope, I wouldn't have done that... Try it and see if you can tell me why I wouldn't.

Here's a hint:

Code:

SELECT log(exp(1)) * Cast(1.2 as decimal(10,2))
,  Cast(1 AS DECIMAL(10, 2)) * Cast(1.2 as decimal(10,2))

-PatP

MCrowley · #**713** (**permalink**) 11-30-12, 10:46

Can't say as I have a lot of experience with NZDF solutions, and checking significant digits (or returned datatype) did not occur to me.

Pat Phelan · #**714** (**permalink**) 11-30-12, 12:53

Understood. A lot of that comes from working with SMEs on really complex computational models. Most of the things that catch my attention are meaningless to most people, but can have significant impact in complex calculations and/or edge cases.

-PatP

Thrasymachus · #**715** (**permalink**) 12-03-12, 09:56

Ugh. You can not buy paper US savings bonds anymore? I thought I had xmas for thie nieces and nephew all wrapped up. Stupid internet.

papadi · #**716** (**permalink**) 12-04-12, 17:14

Quote:

You can not buy paper US savings bonds anymore?

From the Treasury site:
As of January 1, 2012, paper savings bonds are no longer sold at financial
institutions.
Can't get them via payroll deduction either.

How about Amazon gift "cards"?

corncrowe · #**717** (**permalink**) 12-05-12, 22:05

Define paper?

blindman · #**718** (**permalink**) 12-06-12, 11:03

That stuff that software manuals used to be printed on.
The small yellow squares currently stuck to the rim of your computer monitor.
Something that can be shredded.

Thrasymachus · #**719** (**permalink**) 12-07-12, 13:38

Well this is another example of the internet making things worse. So I am not really talking to my sisters right now, so I was going to be passive aggressive about xmas presents for their kids and just throw some savings bonds in some cards and be done with it. This is something that people used to do. Easy.

Now you need a Treasury.gov account and the recipient needs one and if it is a minor it needs to be linked to their parent account. Ahhhh forget it. too much hassle.