Forum Replies Created

Viewing 15 posts - 2,056 through 2,070 (of 2,838 total)

  • RE: Are the posted questions getting worse?

    Grant Fritchey (3/21/2011)


    Roy Ernest (3/21/2011)


    Stefan Krzywicki (3/21/2011)


    Roy Ernest (3/21/2011)


    My wife is going to take some classes on her hobby of Soaps and Candles at Duxbury, Boston. They have only one...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Are the posted questions getting worse?

    Roy Ernest (3/21/2011)


    My wife is going to take some classes on her hobby of Soaps and Candles at Duxbury, Boston. They have only one Bed & breakfast there and from...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Are the posted questions getting worse?

    I'm in Boston

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Are the posted questions getting worse?

    Chad Crawford (3/17/2011)


    Stefan Krzywicki (3/17/2011)


    Roy Ernest (3/17/2011)


    Chad Crawford (3/17/2011)


    Wahoo! Just passed 70-454. I am now officially SQL 2008 DBD ITP. 😀 Yipee!

    Congrats Chad... happy for you......

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Are the posted questions getting worse?

    Roy Ernest (3/17/2011)


    Chad Crawford (3/17/2011)


    Wahoo! Just passed 70-454. I am now officially SQL 2008 DBD ITP. 😀 Yipee!

    Congrats Chad... happy for you... 🙂

    Now would you like to...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Are the posted questions getting worse?

    Chad Crawford (3/17/2011)


    Wahoo! Just passed 70-454. I am now officially SQL 2008 DBD ITP. 😀 Yipee!

    Congratulations, even though I don't know what it means! It sounds good...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (3/17/2011)


    Every so often, I stop and remember that I learn (or remember) things much better if I have to explain it or teach it to someone else.

    I...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Are the posted questions getting worse?

    GilaMonster (3/12/2011)


    Anyone got any suggestions for here: http://www.sqlservercentral.com/Forums/Topic1077027-392-1.aspx

    I posted a link to the article I wrote on this. If he's got invisible text, this should help.

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: join data on strings

    I had a problem with invisible characters awhile ago. Here's how I figured it out.

    Invisible characters in text join[/url]

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Group by

    Brandie Tarvin (3/11/2011)


    Ah. Stefan found the Substring version I was trying to do. I forgot about starting location in CharIndex(). No wonder I couldn't get it to work.

    You're welcome, Roy....

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Are the posted questions getting worse?

    Grant Fritchey (3/11/2011)


    Stefan Krzywicki (3/11/2011)


    Grant Fritchey (3/11/2011)


    GSquared (3/11/2011)


    GilaMonster (3/11/2011)


    I signed off two official design documents back at the bank as "Database Overlord". No one commented.

    I, for one, welcome our new...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Are the posted questions getting worse?

    Grant Fritchey (3/11/2011)


    GSquared (3/11/2011)


    GilaMonster (3/11/2011)


    I signed off two official design documents back at the bank as "Database Overlord". No one commented.

    I, for one, welcome our new reptilian overlords ....

    (Now I...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Group by

    Create table #tempIPTable

    (IPAddress varchar(50));

    Insert into #tempIPTable

    Select '172.24.28.1'

    UNION ALL

    Select '223.25.26.1'

    UNION ALL

    Select '223.25.26.5'

    UNION ALL

    Select '22.25.26.1'

    UNION ALL

    Select '22.25.26.4'

    UNION ALL

    Select '223.25.20.1'

    UNION ALL

    Select '22.25.23.1'

    SELECT FirstTwo, Count(IPAddress)

    FROM

    (SELECT IPAddress , SUBSTRING(IPAddress , 1, CHARINDEX('.', IPAddress , CHARINDEX('.',...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Are the posted questions getting worse?

    DBA - Don't Believe Anyone.

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Are the posted questions getting worse?

    Tom.Thomson (3/10/2011)


    Chad Crawford (3/10/2011)


    jcrawf02 (3/10/2011)


    We actually have annual contests to see who can guess the most acronyms, and we pass out a list to new hires so they're not...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

Viewing 15 posts - 2,056 through 2,070 (of 2,838 total)