Forum Replies Created

Viewing 15 posts - 1,696 through 1,710 (of 4,080 total)

  • RE: The Missing Certification

    To be licensed to practice law in Florida, I had to pass the state bar exam... and don't think there aren't cram courses and outlines for that. ...

    __________________________________________________

    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?

    Lynn, I assume it would be unhelpful for me to join that discussion and suggest indentured servitude?

    __________________________________________________

    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: Stopping Duplicates with INSTEAD OF INSERT Problem

    Hey Matt... I just got some new glasses.

    Is your avatar the Master Control Program from "Tron" ??

    __________________________________________________

    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: How to get last 10 characters in all rows of a single(same) column?

    Kingston, that's why I added the footnote.

    I considered posting a tally table solution, too, but that was probably overkill. 😛

    __________________________________________________

    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: Need help with conditional column

    Good job! Glad its working for you now.

    __________________________________________________

    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: Round currency values

    Paul, you are compelling me to up my game here in the forums. You will be hearing from my wife about the lack of attention she receives while...

    __________________________________________________

    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: Creating Indices on Temp Tables from Stored Procedures

    Any other action is almost certainly suboptimal.

    I can't disagree with this statement, and yet I feel it is incomplete. While optimum performance is always a goal, sometimes the...

    __________________________________________________

    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?

    Dixie, you collect on that one and I will be proud to tell folks that I am your evil twin!

    Hey, I've got a couple free hours a week, Math skills...

    __________________________________________________

    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: Query using the LIKE OPERATOR

    How about ?

    select ....

    from...

    WHERE NAME LIKE isnull(@NAME,'')+'%'

    Also, how about showing us the name you are trying to search, and the string that is in the @name variable. ...

    __________________________________________________

    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: How to get last 10 characters in all rows of a single(same) column?

    No, no, Wayne.... that's just what they'll be expecting him to try!!

    I might have said the following because it's more performant than a RIGHT() function.

    REVERSE(LEFT(REVERSE(LTRIM(RTRIM(colname)),10))

    Please note: People without...

    __________________________________________________

    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?

    Howsabout I email yousa right now?

    __________________________________________________

    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?

    Barry.... how do we know He didn't just do that?

    Don't answer that.... I may do my next article on P=NP. The Clay Institute pays better than SSC.

    __________________________________________________

    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: Pivot Querrie using Dates

    Can the months be fields as well if I dump my results in a temp table?

    Not quite sure what you mean by that. Can you draw us...

    __________________________________________________

    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?

    RBarryYoung (3/25/2010)


    GilaMonster (3/25/2010)


    The Dixie Flatline (3/25/2010)


    ARID = Alternate Reality ID.

    I believe it's parameter 117, but I'd have to confirm that with Gail.

    From what I recall, it's...

    __________________________________________________

    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: Need help with conditional column

    I actually did have an END in my real query but neglected to include it in the shortened version for this post.

    In the future, keep in mind that...

    __________________________________________________

    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,696 through 1,710 (of 4,080 total)