My tired brain is berating my inner self for waiting till the end of the day to look at the QOD. But I'm glad I did.

I was able...

Ah, yes. I've run into a similar situation using Open Query against a remote db table (not even MS SQL, but rather Netezza) that has millions of rows, from which...

You may have been looking for the syntax to specify a table in a different database than where you're connected, but on the same local machine. From BOL (see...

Ray K (12/2/2011)

---

FWIW, if I was going to claim bias, I'd say Curtis Granderson...

Hugo Kornelis (11/28/2011)

---

Technically, T-SQL is not using single quotes for both strings and dates. It uses single...

A good QOD today for a couple reasons. The first, of course, is that it brings to our attention the rather cryptic behavior of SQL not being able to convert...

Good QOD. This rounding quirkiness is why I've made a habit of avoiding BETWEEN with datetime types. If you have to use BETWEEN, then be aware that...

brazumich (11/15/2011)

---

Good question, thank you.

I will "third" liking your question format. It forces us to actually type the code if we want to cheat that way before answering the question.

Or...

Thank you for this mini-lesson in dynamic SQL. And don't fret too much over the minor glitches -- I know from experience that it's a lot harder than it...

Interesting problem, and thank you for sharing the discussion and solution. I do note that the query will ignore hours worked outside the scheduled times. For instance, if you...

Dude63 (10/7/2011)

---

PS. A couple of bad fans do not spoil the bunch. From what I hear from other stadiums, there is just as bad stuff going on there....

Markus (10/7/2011)

---

We are getting closer to a Cardinals/Tigers rematch of 1968 and 2006!.... Could it happen for a third time? Still a long way to go but ya...

and, for what it's worth, a similar posting on SSC from a few months before that other site...

http://www.sqlservercentral.com/scripts/Maintenance+and+Management/62222/

A caveat: as with any software, purchased or freely shared, do test...

L' Eomot Inversé (10/6/2011)

---

I feel much less frightened now: 22%...

L' Eomot Inversé (10/6/2011)

---

Ernie Schlangen (10/6/2011)

---

I make no comment on using the encrypted Google web page you cite in French, because I don't speak French and am apparently not...