Forum Replies Created

Viewing 15 posts - 106 through 120 (of 702 total)

  • RE: Complex joins

    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...

  • RE: Syntax - Open Query - JOIN Linked Server Table with SQL Server Table

    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...

  • RE: Syntax - Open Query - JOIN Linked Server Table with SQL Server Table

    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...

  • RE: Talking baseball

    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...

  • RE: DateTime Precision

    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...

  • RE: ISNULL

    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...

  • RE: Use of DATETIME and BETWEEN - Part 2

    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...

  • RE: Table variable - 2

    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...

  • RE: Parameters

    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...

  • RE: Calculating Incorrect Times from Two Tables without RBAR

    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...

  • RE: Talking baseball

    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....

  • RE: Talking baseball

    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...

  • RE: Query to show jobs and their schedules

    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...

  • RE: Elementary Key Attributes

    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%...

  • RE: Elementary Key Attributes

    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...

Viewing 15 posts - 106 through 120 (of 702 total)