Forum Replies Created

Viewing 15 posts - 751 through 765 (of 3,666 total)

  • RE: Are the posted questions getting worse?

    I think I'm ready for a new thread. I'm seeing way too many responses to questions that not really related to the question asked. The new thread...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Declared Hard coded Variables

    sgmunson (6/3/2015)


    I'm not 100% sure I know exactly what you are looking for, but if you're looking to compute the time difference between two fields that are stored as character...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Date Order

    You need to sort the data by the actual date, not the date converted to varchar.

    In the report,you can display the converted date.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Extracting Numbers from String

    Lowell (6/2/2015)


    Eirikur Eiriksson (6/2/2015)


    Lowell (6/2/2015)


    take a look at this thread from a while ago: it's got some excellent examples on stripping out non-numeric characters in the fastest way possible.

    do you...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (6/2/2015)


    Alvin Ramard (6/2/2015)


    I might need a pork chop soon. I won't care if it's coated in whipped cream, BBQ sauce, or anything else!

    Maybe mint jelly or for...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    I might need a pork chop soon. I won't care if it's coated in whipped cream, BBQ sauce, or anything else!



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Extracting Numbers from String

    ScottPletcher (6/2/2015)


    Alvin Ramard (6/2/2015)


    ScottPletcher (6/2/2015)


    A scalar function will handle that just fine. Particularly if you do it only once, when the data is inserted. You can add a...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Extracting Numbers from String

    Regex sounds like a great idea, but I'm not aware of any way to use it without creating a CLR function.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Extracting Numbers from String

    ScottPletcher (6/2/2015)


    A scalar function will handle that just fine. Particularly if you do it only once, when the data is inserted. You can add a format code /...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Extracting Numbers from String

    I know of any simple way to do what you're asking without using REPLACE.

    FYI, using REPLACE with the format you gave looks pretty simple:

    REPLACE(REPLACE(REPLACE(REPLACE(PhoneNumber, '(', ''), ')',...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    GilaMonster (6/2/2015)


    I'm guessing that google.com is down today. At least the za one still works fine, so I can google for anyone affected by this terrible outage.

    Google worked fine...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    Lynn Pettis (6/2/2015)


    SMH...

    Why would the person who wrote the procedure ask on a public forum why his procedure is returning a value of -6 when executed?

    In this person, weak is...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    Jack Corbett (6/2/2015)


    Alvin Ramard (6/2/2015)


    Brandie Tarvin (6/2/2015)


    So long as no one brings up the whipped cream incident, everything should be fine.

    What about the pork chops? Are they...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: store procedure

    If you want to learn SQL, you should learn how to do Google searches first.

    Try http://www.lmgtfy.com/?q=SQL+stored+procedure



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (6/2/2015)


    Ed Wagner (6/2/2015)


    rodjkidd (6/2/2015)


    Ed Wagner (6/2/2015)


    rodjkidd (6/2/2015)


    Grant Fritchey (6/2/2015)


    Brandie Tarvin (6/2/2015)


    So this[/url] was in the Database Weekly and I found myself snerking about it.

    I have to say that...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Viewing 15 posts - 751 through 765 (of 3,666 total)