Matt Miller (2/13/2008)

---

No offence taken - just setting the bar in case you decide to throw your hat in the ring....

Say - you're not mixing cold meds and nicotine cessation...

Actually, Matt and I beat the daylights...

Heh... ya gotta admit, though... it was funny...

Sorry guys... didn't mean any offense... today's cold medicine still hasn't worn off and it came out all wrong 😛

I guess what I really wanna know from Stricknyn, is are...

Chris,

Good one... Keep in mind that would be good for one row at a time (Rand is not random in a single query) and if the digit "0" were allowed......

About this time, I'm thinking we stop fighting city hall on formats and let something else do the formatting for us... and much nicer than we can make in raw...

Heh... I know how to solve all of this... put all data into a single Name/Value table... primary key will also be all foreign keys and covering indexes :P:):D:hehe:

Lowry Kozlowski (2/13/2008)

---

THANK YOU! JEFF! That is what I was looking for! I can now use this and do some testing with my databases, the sizing statistics just add to...

Cool... thanks for the feedback, Ian.

The way the standards were created is kind of interesting... after a year at my current company, I saw enough crap and ran...

Matt... is that going to work in 2k?

Grant Fritchey (2/13/2008)

---

Jeff,

Doesn't the fact that floats are imprecise estimates represent a pretty major possible problem in using them in financial calculations? At least that's what I've always been told....

Ian Crandell (1/9/2008)

---

Jeff Moden (1/8/2008)

---

We've actually put some "documentation standards" into play at work. They're not so limiting as to suppress innovation, but they do state what must be...

Heh... one of the many reasons I don't use DTS...

I've used Money... I've used SmallMoney... I've even used Decimal... and they all failed the accuracy test when it came to things like mortgage calculations.

If all you're ever going to...

Yes... it does make a difference... about 21% without an order by and about 12% with an order by. But wait...

Heh... on a million rows of data with...