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...

gints.plivna (2/14/2008)

---

If one gets a new car by another vendor he understands that the core functionality is the same i.e. the car can be driven but switches, detectors, the general...

JohnG (2/14/2008)

---

Heh... thanks Steve... I'll consider it. It would be very difficult, though, because I break out in a bad case of Tourette's syndrome every time I try to do...

Christopher Ford (2/13/2008)

---

Earlier Jeff posted a question on using SUM(SAL) OVER()

Since OVER() doesn't support ORDER BY when used with an aggregation.

How about this one?

SELECT J1.AccountID,

J1.Date,

...

While I certainly agree that one should use the right tool for the right job, I'll also be the first to disagree about the shorter the code, the faster it...

Steve Rosenbach (2/14/2008)

---

Hey Jeff!

Sounds like you're a good candidate to write "ORACLE for SQL Server Developers." 🙂

Seriously, would you consider writing an article for SQLServerCentral.com about some of the...

Agreed... basically the same... I've got an extra "Compute Scalar" 'cause of the formatting I did...