Living databases - All Comments

re: Trouble with decimals

anonymous — Mon, 04 Aug 2008 08:55:57 GMT

Hi,

I have been reading this blog for some time now but never bothered to comment until today. Wanted to let you know that I am a fan and enjoy your work.

Thanks,

_________________

<a href=http://www.greencashmoney.com>stock market picks</a> | <a href=http://www.greencashmoney.com>online stock trading tips</a> | <a href=http://www.greencashmoney.com>daily penny stock picks</a>

re: Trouble with decimals

MC1 — Fri, 18 Apr 2008 08:58:03 GMT

Problem here is, you need to allow for max possible values. And SQL allows for (38,20) so that is the datatype in staging area. Obviously, calculations here are done on the columns not variables so its not that easy to catch the real problem. Using only 18,10 would 'fix' the problem but would also limit the possible values in the tables. Are those limits acceptable or not again depends on the environment

re: Trouble with decimals

anonymous — Fri, 18 Apr 2008 08:40:12 GMT

You must be aware when using decimal multiplication in T-SQL. Declaration should be:

declare @q decimal (18,10), @r decimal(18,10), @e decimal (38,20)

and then result will be what user expects.

But also, my opinion is that is better avoid multiplication or any other mathematical operation in T-SQL now when we have CLR enabled in SQL Server.

Regards,

Wrda

re: Trouble with decimals

anonymous — Fri, 18 Apr 2008 08:35:56 GMT

You must be aware when using decimal multiplication in T-SQL. Declaration should be:

declare @q decimal (18,10), @r decimal(18,10), @e decimal (38,20)

and then result will be what user expect.

But also, my opinion is that is better avoid multiplication or any other mathematical operation in T-SQL now when we have CLR enabled in SQL Server.

Regards,

Wrda

re: MS SQL 2005 cluster install

anonymous — Tue, 15 Apr 2008 04:24:21 GMT

gV5GSE <a href="jxraxppiiwxt.com/.../a>, [url=http://eldpinsvhagc.com/]eldpinsvhagc[/url], [link=http://ocrvppxnnyhk.com/]ocrvppxnnyhk[/link], http://cqtkzpknyifm.com/

re: Codecamp Zagreb

tbronzin — Wed, 17 Oct 2007 20:44:24 GMT

I enjoyed your session (if only Kresimir could come :-)).

Tom

re: MS SQL 2005 cluster install

dadamec — Tue, 25 Sep 2007 21:13:08 GMT

> really shouldnt be any surprises right? Wrong!

We had exactly the same reaction with Team System installation. It becomes normal :(