realistically it isn't going to be anywhere near 20 years. If it was only the technology of memory/storage - I'd put it at about 5 years.

Currently an entry level PC...

That would be the B in BODMAS

You are dividing the denominator by 3600 - that is exactly the same mathematically as multiplying the numerator. However due to the computer handling floats using a fixed number of...

try rearranging this

to

ISNULL(round((hs.fractionalPart*dr.LostGeneration*3600/ ( DATEDIFF(SECOND,dr.startTime,dr.endTime))),1),0.0)

If something odd is going on with implicit type conversions in the division this would prevent the problem with...

Hugo Kornelis (11/19/2012)

---

crmitchell (11/19/2012)

---

Hugo Kornelis (11/19/2012)

---

mbova407 (11/19/2012)

---

Thanks for this question. I always hated/never understood this banker's rounding rule. As you can see from this post it is not...

Hugo Kornelis (11/19/2012)

---

mbova407 (11/19/2012)

---

Thanks for this question. I always hated/never understood this banker's rounding rule. As you can see from this post it is not just in Sql

(...)

Like...

Sean of the Lynchmob (11/19/2012)

---

Don't know what sort of school you went to, but the...

You also need to ensure that 'between', 'and' and '(' cannot appear in the text you are trying to extract.

I'd suggest doing this in stages to facilitate future maintenance.

Definitely as...

You mean the rule you were taught at school to round halves to even numbers?

The big problem in this question though is that whilst 3.75 can be stored exactly in...

kramaswamy (10/31/2012)

---

Hi all,

What I discovered eventually is that there are times where GETDATE() and GETUTCDATE(), executed on the same row of the query, occasionally return different results:

GETDATE() : 2012-10-31 13:58:48.933

GETUTCDATE()...

The simple school maths level answer

Never average averages.

The slightly better answer

Never average averages unless the sample sizes of all elements are identical

The reason

suppose you have a set of average speeds...

Sean Lange (10/10/2012)

---

Be careful with approach. Deleting tables just because they haven't been used in a couple months can very likely come back to bite you. What about reports that...

churlbut (10/10/2012)

---

Sorry had to add my two cents about using expressions with Date included in the file name.

This is a bad idea if you will be running the package around...