Forum Replies Created

Viewing 15 posts - 1,516 through 1,530 (of 4,080 total)

  • RE: Are the posted questions getting worse?

    Does the plan involve a fiber-optic laser assembler?

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Speeding up a Spatial query

    I don't think my service-level agreement with you specifies an instant response time, Grant 😉

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Try Catch alters behaviour of existing procedures

    To be fair, I do understand doobya's annoyance at having to change so many of his existing procedures if he's going to use TRY/CATCH. That would make me...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Speeding up a Spatial query

    Lynn, the only reason I'm holding back is it is the subject of an article I'm writing (if it proves out against spatial indexes).

    One of the hangups...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Speeding up a Spatial query

    Okay, thanks. I just sent you an email. Let me know if you got it.

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Speeding up a Spatial query

    Oliver would you post up your schema for your table that contains the polygons? We can talk it through using that as a starting point.

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Speeding up a Spatial query

    Hey guys, I know I'm coming late to the party, but I saw "spatial" pop up and I've been working on that quite a bit lately. Oliver, it...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Issue with Update command

    Like Rishi, I don't understand why you were doing a left join in the first place, but there is something you are not telling us. Your original...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: PRINT vagaries

    edited: never mind

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: CTE Vs. Views

    CTEs are also a technique to improve readability because they read from top to bottom, rather than from inside out like subqueries. I often use them to break...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Are the posted questions getting worse?

    Okay... now I have a dog in that fight.

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Try Catch alters behaviour of existing procedures

    I understand. But you have control of the behavior based on the error severity level.

    From Books Online (the section on RAISERROR):

    When RAISERROR is run with a severity...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Are the posted questions getting worse?

    I'm completely missing the point of the questioner over here. Can someone else give them a hand maybe?

    Grant, I don't have a dog in that fight, but his complaint is...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Can I convert a datetime to just a year/month for a group by?

    So you can. 🙂

    I'll remember that. Thank you, Jeffrey.

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Trigger help

    Could you please tell us what error you are getting? More information may be needed such as what your table schema are, what data is producing the errror,...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

Viewing 15 posts - 1,516 through 1,530 (of 4,080 total)