More amusing anecdotes in a similar vein:

http://www.ussdevilfish.com/images/gall29.htm

Grant Fritchey (3/14/2008)

---

I don't know if I'd call poking holes in water the "front lines" but from what I saw of the AF, you guys had it pretty sweet.

And Jeff,...

Hi Debbie

If you haven't already seen today's article by Jeff Moden about tuning UPDATES, then it's worth a read. There's a 'gotcha' in the code I posted earlier, which should...

Matt Miller (3/13/2008)

---

Grant Fritchey (3/13/2008)

---

I got hired once because I'd been in the Navy... that's as close as I've got to an "outside" talent getting me hired story... Jeez, that...

Scary stuff. With such an exemplary health and safety record, what do you make of this...

http://technology.newscientist.com/article/dn13459-disposable-nuclear-reactors-raise-security-fears.html

A friend who left school in 1975 ("Confessions of an Old Git") to work at...

Yeah come on Steve, let's hear your best story about farting horses! 😛

Don't fink so mate, you made yours and you've a right to be proud of that! It's a different sport to recurve/wheelybow, more fun, less OCD 😎

Heh yeah...

Grant Fritchey (3/12/2008)

---

Nice. I made my long bow in a course with the Royal Bowyer of England. It's only about 50-60lb pull, but it'll throw a bodkin point about 75...

This thread has ample nerdiness for those amused by it! 😛

How close could you get with your axe before one of my nice homemade 32" POC arras pierces your steel breastplate? Of course, any arras left over make good spits...

I'm sure you've checked this out, John, but BOL says of connection-level settings...

"SQL Server evaluates datetime constants at run time. A date string that works for the date formats expected...

John

The implicit conversion of update_timestamp to small datetime is causing the problem. Use explicit conversion...

WHERE sta_code = 'V'

AND CONVERT(smalldatetime, update_timestamp, style) >= @extract_start_date

...replace style with the...

You can't delete a row, but since you can blank out cells, for most purposes is doesn't matter.

heh heh I'm sure you...

You're welcome, Jim. Interesting that it worked for a named range but not for a worksheet (tab). I've only used this with worksheets.

Here's a sproc which you can tailor...