BWAA-HAAA!!! Me too! I just looked those two "new" words...

Steve Jones - Editor (4/7/2009)

---

GilaMonster (4/7/2009)

---

Similar thing here. In my country, woman and IT don't usually go in the same sentence. The number of times I've been 'mistaken' for the...

Jason Miller (4/7/2009)

---

I'm stepping out on a limb...

David Walker (4/7/2009)

---

I won't begrudge you doing whatever you need with multi-page SQL statements (yech) but in your case, I would try a few common table expressions and see what...

xgcmcbain (4/7/2009)

---

its for a business app reason, since my list is so large, and i have multiple apps hitting the same table, each of them grab a chunk...

GSquared (4/7/2009)

---

Jeff, the problem with the convert(int) method is that it, again, relies on the internal storage of datetime, just like the version for float.

Have you tested it in SQL...

I agree with Michael that the DateDiff/DateAdd method is probably the best for guaranteed future compatability.

Here's some code that I wrote a very long time ago (long before...

javid.alimohideen (4/6/2009)

---

True,

I completely agree with you that it is a bug. I was just looking for a quick workaround to keep the process going until I fix it with a...

Heh... actually, I love it being there... I'm currently working as a consultant and gives me more to fix. 😀

wldhrs (4/6/2009)

---

I disagree...

Gift Peddie (4/7/2009)

---

Personally, I don't care if you're black, white, yellow, red, brown, purple, male, female, something in between, have 3 eyes, or glow in the dark... if you can...

Bob Hovious (4/7/2009)

---

Thanks, Jeff. I was feeling the same frustration I used to feel in arguments with my first wife when she would tell me what my...

Jeff Moden (4/7/2009)

---

Specifically, you didn't. Grant mentioned it first...

The 2nd question has nothing to do with SQL, either. It's about a "tabular file".

Specifically, you didn't. Grant mentioned it first and I...