Forum Replies Created

Viewing 15 posts - 196 through 210 (of 272 total)

  • RE: OPENQUERY-1

    TomThomson (3/19/2014)


    Hany Helmy (3/18/2014)


    [Incorrect answers: 80%], hmmm interesting.

    About 36 hours later and the error rate is down to 70%. But still 3% selecting the answer "-1". Definitely interesting.

    I...

  • RE: OPENQUERY-1

    Carlo Romagnano (3/19/2014)


    marcia.j.wilson (3/18/2014)


    I'm not sure I completely understand this.

    Is this what's going on?

    -The query initially adds a single row with a value of 1.

    - The open query returns the...

  • RE: OPENQUERY-1

    I'm not sure I completely understand this.

    Is this what's going on?

    -The query initially adds a single row with a value of 1.

    - The open query returns the deleted set which...

  • RE: EXCEPT 2

    I do appreciate the easy point, even though I don't think I earned it.

  • RE: Understanding Graphical Execution Plans - Part 3: Analyzing the Plan

    Grant Fritchey (2/25/2014)


    For more, follow the links in my signature below. The Execution Plans book is free as a download from here[/url] if you don't want a paper copy.

    Bless you!

  • RE: Character Field Declaration

    Miles Neale (2/14/2014)


    Well I got it right but had a real problem deciding about selecting It starts raining since here in Washington state USA it is always either just...

  • RE: Character Field Declaration

    Nevyn (2/12/2014)


    Technically, every time I have run that command, it has started raining sometime thereafter. Not always right away, but my server isn't very powerful.

    So I think the options...

  • RE: Character Field Declaration

    It seemed worth losing a point just to be able to pick "It starts raining."

  • RE: Temporary table in a batch

    L' Eomot Inversé (2/9/2014)


    ...sometimes (and it seems reasonably certain that this is one of those times) "it's by design" means "someone made a mess of this, but there's not much...

  • RE: Finding “Active” Rows for the Previous Month (SQL Spackle)

    WayneS (2/5/2014)

    Jeff - I would suggest that you take that post, and make it into its own article. It's likely it will be read more than being stuck here in...

  • RE: Software Patents

    djackson 22568 (1/30/2014)


    Patents were intended to protect the efforts required to imagine and develop new things. We now have patents for the human genome, which is absolutely ridiculous. ...

  • RE: Finding “Active” Rows for the Previous Month (SQL Spackle)

    I agree with the comments about this being excellent. I work with a lot of effective-dated information and have been using similar logic for over 20 years (in COBOL...

  • RE: Modified SP_WHOM

    Thanks. I combined this script with what Peter wrote to get information about what's currently active.

  • RE: Binary

    IgorMi (1/1/2014)


    Cool, in

    11111011110

    it was essential to spot that the first two bits (1) and the last one (0) are constructing the right answer.

    Regards,

    IgorMi

    That's pretty much how I did it....

  • RE: Windowing Ranges

    Hugo Kornelis (12/9/2013)


    marcia.j.wilson (12/9/2013)


    Any examples of how these would be used?

    Running totals. Traditionally done with slow set-based code, with a (relatively!) fast cursor, or with some dangerous unsupported side effect...

Viewing 15 posts - 196 through 210 (of 272 total)