Forum Replies Created

Viewing 15 posts - 721 through 735 (of 1,195 total)

  • RE: Commenting

    Brandie Tarvin (9/26/2013)


    At risk of starting another rant, if you're already updating the stored procedure, variables are easy enough to rename.

    Already thought of that one Brandie - however I would...

    -------------------------------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: Commenting

    If only I could Gail - I would take Mr Shinai to them. Sadly they left before I started here.

    -------------------------------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: Commenting

    Thanks for all the replies. Glad to see that there is ageement

    They say the devil is in the detail, now here is the situation with all the information. I have...

    -------------------------------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: Bulk Insert - CSV with and without quotes

    Deleted - re-read the question and I was wrong

    -------------------------------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: Executing Dynamic SQL

    Nice and easy today - thanks

    Knew the answer to this through bitter experience 🙂

    -------------------------------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: Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation. [SQLSTATE 42000] (Error 468). The step failed.

    I come across this one from time to time with different third party applications.

    Somewhere in your procedure, on a comparison field (i.e. tablea.col1 = tableb.col1)

    you need to add

    collate...

    -------------------------------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: wildcards

    ChrisM@Work (9/11/2013)


    Hany Helmy (9/11/2013)


    I am really amazed of the 16 people (as of now) who got it right! :w00t:

    Hope one of them will post a reply explaining how he got...

    -------------------------------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: Good and Bad Interview Questions

    I agree whole heartedly with you on this one Steve. I’ve had some bizarre interviews questions -What kind of animal would you be and why?“ technical ones “What is the...

    -------------------------------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: Stunned

    Haven't seen an editorial create so many responses so quickly for a while.

    Amit Pandey DeBugSQL (8/30/2013)


    Lol, Looks like the person who gave these comments doesnot follow the forums. How can...

    -------------------------------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: need help in a stored procedure

    Hi,

    Have you got any sample data we can have a look at - also how far have you got?

    Could you please post what you have so far? - You might...

    -------------------------------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: Report writer on vacation. Never used SSRS. Simple question about "where is the data request accessed"

    What version of VS are you using?

    -------------------------------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 find sql installed services on server

    Have you looked at the Microsoft Assessment and Planning Toolkit - it scans your network and produces a load of reports about what SQL instances etc are running.

    -------------------------------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: Data Problem

    And the table script and inserts for the other two tables involved in the query are . . .?

    This might sound harsh but this is not the first time...

    -------------------------------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: Data Problem

    To help us to help you, can you please read through the "Posting Data Etiquette - Jeff Moden " link below and then post the info again.

    Trying to use the...

    -------------------------------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: User with total points more than 30000?

    Koen Verbeeck (8/16/2013)


    Richard Warr (8/16/2013)


    So, the people who based their answer on the documentation got it wrong, whilst those who used "real data" got it right.

    Perhaps there's a lesson to...

    -------------------------------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 - 721 through 735 (of 1,195 total)