Viewing 15 posts - 106 through 120 (of 702 total)
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...
December 6, 2011 at 6:48 pm
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...
December 2, 2011 at 11:03 pm
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...
December 2, 2011 at 6:38 pm
Ray K (12/2/2011)
calvo (12/1/2011)
Ellsbury deserved the AL MVP (bias much?).Verlander is just a pitcher, they have their own awards
FWIW, if I was going to claim bias, I'd say Curtis Granderson...
December 2, 2011 at 9:58 am
Hugo Kornelis (11/28/2011)
roger.plowman (11/28/2011)
Using single quotes for both strings and dates is a brain-dead design decision--period.
Technically, T-SQL is not using single quotes for both strings and dates. It uses single...
November 28, 2011 at 11:05 am
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...
November 23, 2011 at 1:59 pm
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...
November 18, 2011 at 5:15 pm
brazumich (11/15/2011)
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...
November 15, 2011 at 5:06 pm
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...
November 3, 2011 at 10:27 am
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...
October 7, 2011 at 7:02 pm
Dude63 (10/7/2011)
October 7, 2011 at 12:30 pm
Markus (10/7/2011)
October 7, 2011 at 11:45 am
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...
October 6, 2011 at 6:31 pm
L' Eomot Inversé (10/6/2011)
L' Eomot Inversé (10/5/2011)
I find it quite frightening that so few people know enough about normalisation to get this one right.
I feel much less frightened now: 22%...
October 6, 2011 at 6:07 pm
L' Eomot Inversé (10/6/2011)
Ernie Schlangen (10/6/2011)
October 6, 2011 at 3:01 pm
Viewing 15 posts - 106 through 120 (of 702 total)