Forum Replies Created

Viewing 15 posts - 54,466 through 54,480 (of 59,067 total)

  • RE: how to remove numbers from strings?

    Why would you think that that would remain unquestioned, when it was simply a repeat of the personal attack, that again, has no place in this forum?

    Sorry, David, I sure...

  • RE: how to remove numbers from strings?

    OMG... what a complete rookie copy'n'paste mistake on my part... :blush: I'm so sorry...

    Lowell, here's the code, one more time... would you and David please do the honors? ...

  • RE: Saving binay data to disk via TSQL???

    Heh... I actually haven't tried it because I won't allow folks to store images in our databases... but I don't see why it wouldn't work... it's just another form of...

  • RE: SQL Server Periodically Hangs - Troubleshooting Suggestions?

    Hi Dave,

    Man, I feel for ya... been there my own self...

    Just curious, though... even if the code were just "the straw that broke the camel's back", if it has known...

  • RE: simplifying code

    Heh... that's what "embedded comments" are for 🙂 But, I understand...

  • RE: how to remove numbers from strings?

    I'd add things like PIVOT

    Cool... Once we figure out what's meant my "missing subtrahend" in the previous code and retest, I'd love to do a test on the very...

  • RE: how to remove numbers from strings?

    Look at the code again, but this time play a game of "Find the missing subtrahend" while doing so.

    Thanks for the test, David...

    Haven't "studied" the code... what do...

  • RE: Preventing Page Locks

    Just to support what's already been stated... I agree... "too much" blocking is normally caused by long winded transactions or other code that simply takes too long... indexes may help,...

  • RE: simplifying code

    No, no! The Tally table in this code was just to have a table to demonstrate from... I copied it from the previous post that MrPoleCat posted... (heh, you...

  • RE: how to remove numbers from strings?

    Outstanding! And on a Sunday, no less! You ARE the MAN, Lowell!

    I don't know about anyone else, but while a lousy 9 second difference on a lousy million...

  • RE: Adding workdays

    Sergiy (10/20/2007)


    Probably you never got into this task seriously.

    Yeah... absolutely correct... and I guess I need to learn how to use a date table for these types of things with...

  • RE: how to remove numbers from strings?

    David McFarland (10/20/2007)


    Now I'm dying to ask, and please don't take it personal. What does this have to do with this thread (or even that other thread, if that's what...

  • RE: how to remove numbers from strings?

    Lowell (10/21/2007)


    ok here's some performance numbers from my machine, which has both SQL2000 and SQL 2005:

    Jeff's inner join example took ...

  • RE: how to remove numbers from strings?

    So what?

    Heh... HOT DAMN! One performance test coming right up... somebody run the following in 2k5 'cause I still don't have it yet... I removed the ORDER...

  • RE: how to remove numbers from strings?

    David,

    You know I'm dying to ask... and please don't take it personal...

    Do you have a math background or not?

Viewing 15 posts - 54,466 through 54,480 (of 59,067 total)