DOH! (making thumbsucking noises and triddling hair)... sometimes I just get balled up on things. Of course, Greg!... Nice simple solution like that is the way to go....

Matt S... yeaup... a bit "contrived" as you say... the example is meant to mimic the real world where people forget what datatype they're using to do calculations and the...

GSquared (2/15/2008)

---

Even in that case, using float instead of decimal resulted in a measureable speed increase. (I have to calculate distances between sets of up to 4-million records and...

Caught me? Heh... I jumped right out in front of ya 😀

What you say is similar to what I used to say and think.

ALZDBA (2/15/2008)

---

Well it certainly started with a great article, handling a fairly common issue 😎

And it resulted in a solution that worked a lightning speed and performed

the actual update in...

Ross McMicken (2/15/2008)

---

The biggest issue we've had with using money datatypes is that reports in Crystal, and other tools, put a $ sign on each foeld by default. Given tha...

matt stockham (2/14/2008)

---

I would say use whatever datatype is appropriate - if the potential range of stored values falls within smallmoney then go for it. Decimal is useful in...

A primary key of more than 16 columns... Lordy, I sure hope someone doesn't think of that as "core" functionality... :hehe:

So... what would you do with 99.99 shares and 4 people? Decimal isn't going to hack that, either.

Implementation of float in your 3 person case would be as follows...

DECLARE...

Thanks, Aaron...

Absolutely NOT...

And, I agree with Matt... your co-worker doesn't know what he/she is talking...

The columns are self sizing... makes real pretty emails... you send an email with the file as an attachment.

ie... SUBJ: Your daily report on whatever is attached.

Now,...

In other words, please see the following URL...

http://www.sqlservercentral.com/Forums/Topic418139-8-1.aspx#bm418200

...and don't worry... provided you call it correctly and learn how to use the "Increment" as I've laid out in the URL above,...

This has all been totally awesome! Give yourselves a huge pat on the back... 122 posts on a fairly controversial subject and no flame wars. My hat is...

Yep... tested the heck out of the CTE solution with ROW_NUMBER() for the running balance... without the clustered index on the appropriate columns, if falls apart in that the running...