nathan 7372 (3/2/2010)

---

Thats the funny thing about decimal places. Technically, you are both right. Obviously Jeff's higher precision datatype leads to a more mathematically accurate answer. At...

The only question I would have asked is whether you'd confirmed with your business side that the interest is compounded monthly and not daily or continuously. To support daily compounding,...

Tom.Thomson (2/28/2010)

---

john.arnott (2/26/2010)

---

Aside from the typo, this was a good one. It introduces the concept simply and provides a good resource for further understanding. Although I'd learned long...

extracurricular

Is this an Excel 2007 (xlsx) file? If so, you may need to install a newer data provider. I'll admit not being experienced using a direct connection with...

Besides the method of calculating and updating, you'll want to reconsider the datatype choices. Generally, FLOAT is inappropriate for financial calculations due to rounding issues. Microsoft recommends DECIMAL instead.

See...

Aside from the typo, this was a good one. It introduces the concept simply and provides a good resource for further understanding. Although I'd learned long ago that...

Paul White (2/24/2010)

---

RBarryYoung (2/23/2010)

---

Give it a go, Paul. The solution that we (independently) came up with is pretty darn efficient, so I would be particularly interested to see if...

Nice tool to know of. BTW, although the QOD starts off saying "in SQL 2008...", the INSTEAD OF option is documented for SQL 2005 as well.

I know I must be one. My thought on seeing the 12000 mark go by was "less than 300 till the 12K mark."

RBarryYoung (2/23/2010)

---

Why do Ozzies (Ozzites? Ozzians? Ozmen?...) also think that jokes involving sheep are funny? I never did get this ... 😀

[/Quote]

In my limited experience, the Aussies...

Why would you want to update the time (or increment a counter) in a number of rows every 5 seconds? Are other columns being updated too? Does names.count get...

l.ronnoco (2/20/2010)

---

SELECT 1 + (DATEDIFF(DAY, 0, @target_date)+700000) % 7

The 700000 can be any number divisible by 7. This will work all the way back to before the year 0...

This works because 1 January 1900 was a Monday.

I knew that tidbit (and used it in a comment on Lynn's...

Nice tip, Divya. I'm adding this to my bookmarks next to that for "Some Common Date Routines" that Lynn Pettis put up a while ago.

---

Edit to correct link