Forum Replies Created

Viewing 15 posts - 511 through 525 (of 1,251 total)

  • RE: Picking the Correct Row

    Ken McKelvey (3/30/2016)


    Your problem is that postcodes are designed to direct mail so postcode districts do not always tie up with geographic areas of administration.

    I suspect you are going 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

  • RE: Picking the Correct Row

    Jon-183221 (3/30/2016)


    "If I could directly assign postcodes to a police force it would be much easier but as I said above I would end up with other problems."

    Ok, scrap my...


    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

  • RE: Picking the Correct Row

    ChrisM@Work (3/30/2016)


    Jon-183221 (3/30/2016)


    I only have a small insight to what you need to do but why can't you allocate the postcodes against the Account (police force) as this is where...


    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

  • RE: Picking the Correct Row

    Jon-183221 (3/30/2016)


    I only have a small insight to what you need to do but why can't you allocate the postcodes against the Account (police force) as this is where 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

  • RE: Picking the Correct Row

    I'll try to explain the best I can.

    The basic set up is each postcode maps to part of a city or part of a county. Each city...


    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

  • RE: Picking the Correct Row

    Sorry Chris but I'm really not following you. I'm still getting two rows for the EC1 area.

    However, I've got something that is doing what I need now. It'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

  • RE: Picking the Correct Row

    Am I missing something there Chris? That just looks like my original code re-formatted.


    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

  • RE: On-Time, or Not

    Punctuality is important to me, if you're supposed to be there at 1000 be there for 1000. That, to me, means allowing enough time for the trip plus a...


    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

  • RE: Today's Random Word!

    Ed Wagner (3/18/2016)


    ZZartin (3/18/2016)


    Manic Star (3/18/2016)


    Ed Wagner (3/18/2016)


    gsc_dba (3/18/2016)


    Grumpy DBA (3/18/2016)


    Ed Wagner (3/18/2016)


    Smoke

    (on the) Water

    transparent

    Opaque

    Aluminum

    Whales

    Voyage

    Fantastic


    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

  • RE: Today's Random Word!

    BL0B_EATER (3/18/2016)


    ThomasRushton (3/18/2016)


    Ed Wagner (3/17/2016)


    djj (3/17/2016)


    Grumpy DBA (3/17/2016)


    Manic Star (3/17/2016)


    Light

    Beer

    Ale

    Pub

    database

    page

    plant


    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

  • RE: Send a notification when a backup is succesful or failed

    georgheretis (3/18/2016)


    hi

    i am sing a stored procedure in order to backup my DBs. then i shedule it in a job .

    in order to Verify a success of database backups i...


    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

  • RE: Are the posted questions getting worse?

    TomThomson (3/10/2016)


    Eirikur Eiriksson (3/10/2016)


    TomThomson (3/10/2016)


    Steve Jones - SSC Editor (3/10/2016)


    Data Driven going on now: https://www.microsoft.com/en-us/server-cloud/data-driven.aspx

    Quite interesting. Some of it extremely expressive. Certainly backs up what...


    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

  • RE: Today's Random Word!

    Grumpy DBA (3/9/2016)


    Ed Wagner (3/9/2016)


    Stuart Davies (3/9/2016)


    shipping

    Receiving

    Yards

    Hard


    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

  • RE: Today's Random Word!

    djj (3/4/2016)


    Ed Wagner (3/4/2016)


    crookj (3/4/2016)


    djj (3/4/2016)


    Grumpy DBA (3/4/2016)


    Ed Wagner (3/4/2016)


    Lies

    Clintons

    Server

    Email

    Cloth

    Stain

    Glass


    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

  • RE: Today's Random Word!

    Luck


    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 - 511 through 525 (of 1,251 total)