Forum Replies Created

Viewing 15 posts - 316 through 330 (of 1,251 total)

  • RE: How to correct this timestam for the current day?

    GilaMonster (1/6/2017)

    I'm not sure I understand what results you're trying to get.

    Neither am I...

    But, assuming that your numbers table is a list of consecutive integers, then removing the '-' will...

    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 6, 2017 at 4:13 am

    #1921064

  • RE: Are the posted questions getting worse?

    Luis Cazares (1/5/2017)

    Phil Parkin (1/5/2017)

    Does anyone have any idea why a thread I created yesterday

    http://www.sqlservercentral.com/Forums/FindPost1847804.aspx

    appears to have removed or marked as spam?

    Maybe you were selling kitchens? Or fake documents? :hehe:

    Dammit,...

    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 5, 2017 at 7:24 am

    #1920869

  • RE: What Will 2017 Bring?

    Gary Varga (1/4/2017)

    ThomasRushton (1/4/2017)

    ...Brexit means Brexit. Apparently. Talk about an omnishambles...

    Today "Leave" means "Leave" according to IDS. Brilliant.

    I can apply the same logic to show my excellent SQL...

    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 5, 2017 at 5:17 am

    #1920842

  • RE: Looking Back at 2016

    Beatrix Kiddo (1/4/2017)

    Geoff.Sturdy (12/29/2016)

    we in the UK voted to remove our country from the EU - pretty much for the same reasons that the founding fathers rebelled against Imperial...

    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 4, 2017 at 8:05 am

    #1920628

  • RE: Finding First Occurrence in a given year

    jon.wilson (1/3/2017)

    Sample data provided in previous post expected output would be

    Year Number of First Time Award recipients

    2012 40

    2013 ...

    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 3, 2017 at 8:49 am

    #1920406

  • RE: Finding First Occurrence in a given year

    jon.wilson (1/3/2017)

    I'm trying to find the first occurrence of a specific incident during a given time period. An example would be a first time award winner is defined by...

    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 3, 2017 at 8:17 am

    #1920393

  • RE: How to get sum to any last 7 days period of month in sql

    saklanivijay87 (12/23/2016)

    I want to get sum of any last 7 days periods of month.

    Date ...

    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

    December 23, 2016 at 3:47 am

    #1919490

  • RE: HASHBYTES limits

    edwardwill (12/21/2016)

    BWFC (12/21/2016)

    edwardwill (12/21/2016)

    The article you cite in support of the answer is silent on the limits to the size of the input string.

    Technically it's not.

    Then please point me to...

    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

    December 21, 2016 at 7:35 am

    #1919146

  • RE: HASHBYTES limits

    edwardwill (12/21/2016)

    The article you cite in support of the answer is silent on the limits to the size of the input string.

    Technically it's not.

    For SQL Server 2014 and earlier, allowed...

    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

    December 21, 2016 at 7:10 am

    #1919136

  • RE: Are the posted questions getting worse?

    rodjkidd (12/20/2016)

    Grant Fritchey (12/20/2016)

    ChrisM@Work (12/20/2016)

    Grant Fritchey (12/20/2016)

    ChrisM@Work (12/20/2016)

    Grant Fritchey (12/20/2016)

    BLOB EATER (12/20/2016)

    is that what they label it as "networking evening" on the Tuesday?

    No, Friday night. The costume ball.

    Have they...

    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

    December 20, 2016 at 6:36 am

    #1918891

  • RE: Are the posted questions getting worse?

    GilaMonster (12/20/2016)

    BWFC (12/20/2016)

    Grant Fritchey (12/20/2016)

    The party at Telford was the single best Bits party that I've been to (disclosure, I've only been to the SQL Bits events since Nottingham, so...

    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

    December 20, 2016 at 5:42 am

    #1918872

  • RE: Are the posted questions getting worse?

    Grant Fritchey (12/20/2016)

    The party at Telford was the single best Bits party that I've been to (disclosure, I've only been to the SQL Bits events since Nottingham, so any previous...

    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

    December 20, 2016 at 4:44 am

    #1918860

  • RE: Are the posted questions getting worse?

    Beatrix Kiddo (12/20/2016)

    I know, it's just getting there. I'd prefer not to stay overnight. (I doubt work would pay anyway, but will find out.)

    + 1

    It's an awkward place to get...

    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

    December 20, 2016 at 2:51 am

    #1918835

  • RE: Are the posted questions getting worse?

    BLOB EATER (12/20/2016)

    Hugo Kornelis (12/19/2016)

    BLOB EATER (12/19/2016)

    I am 90% sure that I will be going to sqlbits in April, anyone else know if they will be there?

    I've been chosen to...

    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

    December 20, 2016 at 1:31 am

    #1918818

  • RE: Are the posted questions getting worse?

    I've just registered for the Saturday. Thanks for the reminder!

    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

    December 19, 2016 at 7:17 am

    #1918669

Viewing 15 posts - 316 through 330 (of 1,251 total)