I just looked you up in our corporate directory and if you live in Addison Tx, then we definitely...

I'm one of the lucky ones. My employer already gives me many benefits:

health insurance

Work at Home

Pays for Phone line and Internet

Flexible Hours

Results based performance ratings.

computer refresh every 3 years.

4...

Tom.Thomson (3/20/2010)

---

The ability to fix..with the click of a button: shouldn't that be qualified with "sometimes"? Without the qualification, does it mean "always" - in which case isn't...

Carlo Romagnano (11/25/2009)

---

WARN: If you use an aggregate function @a will be updated also if no row is returned

[font="Arial"]SET NOCOUNT ON

declare @vals table (iKey int, iValue int)

insert...

I almost selected the option that said there would be an error on the first select because the query should return more than one value.

select @a = iValue...

honza.mf (11/19/2009)

---

Try Google itself. One of the first links leads to ?????????, use English on the left side.

Translator ommited the first word. To tell the truth, the more simple to...

honza.mf (11/19/2009)

---

According to Google Translate, it means: Foucault

Don't know what that means but when I look it up...

That is...

rparakalla (11/17/2009)

---

If you really consider the practical purpose of getdate() & getutcdate(). One would either use Getdate() or getutcdate(). But not both in the same table for audit purpose. For...

slange-862761 (11/17/2009)

---

This conversation reminds me of a time when a developer decided that he would change the way an audit table was used. His idea was that using GETUTCDATE() was...

What about daylight savings time? Getdate() accounts for that because the server time changes. Does the UTC time take into account? I doubt it. So when...

Same here. That is annoying. Sometimes it works right, sometimes you have to...

Lynn Pettis (11/17/2009)

---

Well then, parallelism must be working on my system here because I have run this 10,000 times and don't have a discrepancy between them. System here has...

[Quote]Even in a batch... the odds are about 50/50 that I'll get different results for the miliseconds.. the odds shrink quite a bit for differing seconds.

Union Results

(No column name) (No...

David_Simpson (11/17/2009)

---

I did not even bother to try and analyze the queries, once I read that the GETDATE() function was executed 4 different times, the only possible answer was false...