Forum Replies Created

Viewing 15 posts - 961 through 975 (of 1,195 total)

  • RE: ISNULL

    Nice straight forwards QOTD - thanks

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx

  • RE: DATETIME 2

    Got me thinking - good question.

    Thanks

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx

  • RE: load textfile with fixed record lenght and no delimmiters

    Off the top of my head (not a lot of info to go on) create a temp / staging table then bcp / bulk insert the file and use substring...

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx

  • RE: Order of Execution

    SQLPhil (7/24/2012)


    Having only one option that started with FROM made it very straightforward. Useful to still refresh the memory with the sequence so thanks for the question (and easy...

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx

  • RE: Are the posted questions getting worse?

    rodjkidd (7/12/2012)


    ..... Now looking forward to SQL in the City on Friday in London. . . .

    Can't agree more - this will be the first time in three years my...

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx

  • RE: Database

    Henrico Bekker (7/12/2012)


    Koen Verbeeck (7/12/2012)


    Maybe a little bit too easy 😀

    But apparently some people still get it wrong.

    Or maybe they just sneezed while picking the answer and thus accidentily clicking...

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx

  • RE: String Length

    Good question - thanks

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx

  • RE: The Beer Cooler Thread

    Cliff Jones (7/10/2012)


    You guys have me all interested in coming to the UK to try all the fine Ales available there.

    I'm sure you would be made more than welcome

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx

  • RE: The Beer Cooler Thread

    Andy Hyslop (7/10/2012)


    10 pints where consumed in the space of around 3-4 hours

    /Tips Hat

    Impressive!!

    I'd be no good for anything after that!! :sick:

    My days for that sort of thing are...

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx

  • RE: The Beer Cooler Thread

    anthony.green (7/10/2012)


    Old Empire is a great favourite of mine, can remember a night at uni where 10 pints where consumed in the space of around 3-4 hours. They where...

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx

  • RE: The Beer Cooler Thread

    Two favourite ales of mine one found here

    http://www.marstonsbeercompany.co.uk/our_brands/marstons/oldempire.asp

    and the other here

    http://www.innisandgunn.com/en/the-range/original.aspx

    Not beers for drinking by the bucket full though - they pack a bit of a punch as well as...

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx

  • RE: Sequences I

    Good question today, thanks - took an educated guess and got it wrong.

    Looks like I need more education.

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx

  • RE: SELECT options

    Definitely had to earn my point today - took a fair bit of thought.

    Good question, thank you

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx

  • RE: Contained Database users

    Another question from Steve on contained databases. I wonder what he has been playing around with?

    😉

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx

  • RE: How to you use dbmail with BCP

    jfogel (4/5/2012)


    SELECT

    '"'+Field1+'"' + ',' +

    '"'+Field2+'"' + ',' +

    '"'+Field3+'"' + ',' +

    ...

    Fieldn AS TheOutput

    FROM table

    Wrap them in double quotes in case anything has a comma in it.

    Good catch

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx

Viewing 15 posts - 961 through 975 (of 1,195 total)