Forum Replies Created

Viewing 15 posts - 541 through 555 (of 1,251 total)

  • RE: Differing Row Counts

    That was just a back-of-a-fag-packet, as-I-type guess. I'm in the process of breaking things open to have a look now and already I've spotted one reason why I've lost...

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    February 5, 2016 at 7:44 am

    #1856845

  • RE: Differing Row Counts

    Thanks Hugo, I appreciate I didn't provide a lot of detail but at this stage I only wanted find out whether it was always a problem or not. I'm...

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    February 5, 2016 at 3:52 am

    #1856794

  • RE: Select Statement retun records between 12:AM and 12:03 AM

    Welsh Corgi (2/4/2016)

    I'm trying to perform a Select Statement to a record between 12:AM and 12:03 AM

    select

    j.name as 'JobName',

    run_date,

    run_time,

    msdb.dbo.agent_datetime(run_date, run_time) as 'RunDateTime'

    From msdb.dbo.sysjobs j...

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    February 4, 2016 at 5:58 am

    #1856504

  • RE: Today's Random Word!

    Stuart Davies (2/4/2016)

    djj (2/3/2016)

    whereisSQL? (2/3/2016)

    Ray K (2/3/2016)

    Ed Wagner (2/3/2016)

    Revenant (2/3/2016)

    Ed Wagner (2/3/2016)

    DonlSimpson (2/3/2016)

    Ed Wagner (2/3/2016)

    Grumpy DBA (2/3/2016)

    Ed Wagner (2/3/2016)

    Padmay

    Naboo

    Coruscant

    Rome

    Italy

    Pasta

    Fettuccine

    Alfredo

    Parmesan

    Chicken

    Licken

    Finger

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    February 4, 2016 at 1:25 am

    #1856462

  • RE: Today's Random Word!

    Ed Wagner (2/2/2016)

    Grumpy DBA (2/2/2016)

    Ed Wagner (2/2/2016)

    HappyGeek (2/1/2016)

    Ironside

    Constitution

    HMS Guerriere

    Battle

    Abbey

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    February 2, 2016 at 5:55 am

    #1855949

  • RE: Spatial Index not applying

    There are certainly some great minds on here.

    If you're looking for a MySQL forum, the first place I'd try is here. I can't vouch for how good it is...

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    January 31, 2016 at 3:44 am

    #1855550

  • RE: Spatial Index not applying

    Hi Evan,

    welcome to the forum. Although I'm now about to try and scare you off. This is a SQL Server forum and although I'm sure there are...

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    January 29, 2016 at 8:48 am

    #1855264

  • RE: Are the posted questions getting worse?

    Sean Lange (1/29/2016)

    BL0B_EATER (1/29/2016)

    Have you guys during your careers ever thought about doing something else in life.. as opposed to IT / SQL Server / Coding etc etc?

    For me IT...

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    January 29, 2016 at 7:57 am

    #1855245

  • RE: Are the posted questions getting worse?

    BL0B_EATER (1/29/2016)

    Have you guys during your careers ever thought about doing something else in life.. as opposed to IT / SQL Server / Coding etc etc?

    Definitely, I'd love to earn...

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    January 29, 2016 at 5:16 am

    #1855195

  • RE: Hard Data v Gut Feel

    Whilst gut feel shouldn't be ignored neither should the data.

    There's the situation when you have the hard data in front of you and your gut feel is they're wrong....

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    January 20, 2016 at 1:17 am

    #1853046

  • RE: Checkpoint

    I got one of Andy's right!!!!!

    It's something I'd actually seen recently myself and I knew(!) the answer without looking it up. Of course being one of Andy's...

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    January 15, 2016 at 1:01 am

    #1852169

  • RE: Eliminate WHILE loop

    After having time to look at that properly, I see exactly what it does.

    I can't believe I didn't think of using the Tally table method. I've put...

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    January 14, 2016 at 2:55 am

    #1851841

  • RE: Eliminate WHILE loop

    Thanks Jeff, that's fantastic.

    I've got a Tally table on my laptop but it didn't even cross my mind to use it. I forget how useful they can be....

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    January 13, 2016 at 8:48 am

    #1851601

  • RE: Today's Random Word!

    Ed Wagner (1/12/2016)

    Grumpy DBA (1/12/2016)

    BWFC (1/12/2016)

    Deuce 😀

    #2

    Initial Specifications

    Vague

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    January 12, 2016 at 7:19 am

    #1851296

  • RE: Today's Random Word!

    Ed Wagner (1/12/2016)

    whereisSQL? (1/11/2016)

    Ed Wagner (1/11/2016)

    Revenant (1/11/2016)

    DonlSimpson (1/11/2016)

    SQLRNNR (1/11/2016)

    whereisSQL? (1/11/2016)

    djj (1/11/2016)

    Ed Wagner (1/11/2016)

    Eirikur Eiriksson (1/11/2016)

    whereisSQL? (1/11/2016)

    Ed Wagner (1/11/2016)

    SQLRNNR (1/11/2016)

    Grumpy DBA (1/11/2016)

    Hugo Kornelis (1/10/2016)

    TomThomson (1/10/2016)

    Eirikur Eiriksson (1/10/2016)

    Behind

    DoesThisDressMakeItLookBig

    It's not the dress, dear!

    Lie

    DefinitelyBetterThanTheDogHouse

    Trouble

    Maker

    Match

    Expression

    Code

    Black

    Ops

    Intrigue

    007

    Bond

    Bail

    Out

    Deuce...

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    January 12, 2016 at 5:27 am

    #1851271

Viewing 15 posts - 541 through 555 (of 1,251 total)