Forum Replies Created

Viewing 15 posts - 121 through 135 (of 1,251 total)

  • Reply To: Stored Procedure Documentation

    Jeff Moden wrote:

    jonas.gunnarsson 52434 wrote:

    As in most development the code should speak for it self, and you should use:

     

      <li style="list-style-type: none;">
      <li style="list-style-type: none;">

     

      <li style="list-style-type: none;">
      <li style="list-style-type: none;">

    • Source control...


    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

  • Reply To: The 2019 Techie Gifts

    If you're worried about Alexa listening to everything, I can say that it (she?) doesn't listen when I ask to switch the bloody cellar lights on so I'd be surprised...


    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

  • Reply To: SQL Cursor Trouble

    OK, we're getting somewhere now.

    The big question is how to you unambiguously tie folder to folder2.  I can see what you want to do but there's no way to guarantee...


    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

  • Reply To: SQL Cursor Trouble

    Hello and welcome to the forum.

    You almost certainly don't need a cursor for this but to get the best help we'll need a bit from you.  It's much easier 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

  • Reply To: The Derived Table

    This may sound like an extremely basic question but what's the difference between an execution error and a syntax error in this case?  The message that I get suggests that...

    • This reply was modified 6 years, 7 months ago by Neil Burton.
    • This reply was modified 6 years, 7 months ago by Neil Burton.


    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

  • Reply To: Ending a line with a Backslash

    But why are you copying the code the get the answer in the first place..?

    Trust but verify 🙂  Besides, a true smart-alec would have known that a '\' would 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

  • Reply To: Ending a line with a Backslash

    I copied,  pasted and ran the code as-is and got the wrong answer.

     


    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

  • Reply To: The Costumed DBA

    It'll have to be a cowboy outfit.


    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

  • Reply To: Finding out mismatch between time lines.

    I did have a solution that worked without a calendar table but I spotted a mistake.

    It's probably worth pointing out that there is no 31st of June.

    • This reply was modified 6 years, 8 months ago by Neil Burton. Reason: Mistake spotted


    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

  • Reply To: Are the posted questions getting worse?

    Thom A wrote:

    BrainDonor wrote:

    SQL Saturday in Edinburgh  - 1st Feb, anybody from here thinking about going?

    Haven't been to Edinburgh since I was about 14, but planning to go there next...


    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

  • Reply To: Are the posted questions getting worse?

    We have a table with one column as UTC and another as local time.  So far this hasn't caused any (major) problems but I'm pretty sure that it will bite...


    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

  • Reply To: Unreliable Data Sensors

    kiwood wrote:

    There are, essentially, no moving parts or complex electronics to go wrong.  It just works.

    I would suggest that you look a little closer. There are a hug number of...


    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

  • Reply To: Unreliable Data Sensors

    The Mark I mirror is a device where the phrase 'if it ain't broken, don't fix it' is extremely apt.  There are, essentially, no moving parts or complex electronics 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

  • Reply To: Are the posted questions getting worse?

    I used to have a pair of running shorts with a key pocket at the back.  One morning I waved my wife off to work, took a look at the...


    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

  • Reply To: Are the posted questions getting worse?

    Sean Lange wrote:

    Yes I agree this website is slowing down. Not just performance but activity as well.

    On another topic of slow...here was this last weekends goods from the smoker.

     

      <li style="list-style-type:...


    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

Viewing 15 posts - 121 through 135 (of 1,251 total)