Forum Replies Created

Viewing 15 posts - 511 through 525 (of 667 total)

  • RE: Getting all identity values in a batch insert statement

    Do you have another (natural) key on the data you are bulk-inserting? If yes you could just re-select the ID column for those keys. That's of course assuming that the...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

  • RE: Ignore Violation of PRIMARY KEY constraint

    Honestly, I would never ignore a row that produces a duplicate primary key. Primary keys are there to uniquely identify a row in a table when it comes to extracting,...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

  • RE: Are the posted questions getting worse?

    Gaby Abed (7/14/2009)


    Here's something scary, regarding Barney (the freaky purple dinosaur):

    CUTE PURPLE DINOSAUR is the number of the beast. You don't believe me? Convert all the U's to...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

  • RE: Are the posted questions getting worse?

    GilaMonster (7/14/2009)


    Jan Van der Eecken (7/14/2009)


    Are you saying I'm out of the office at an inapproriate time?

    It's 10pm. What self-respecting IT person is not still working at this .... oh...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

  • RE: Are the posted questions getting worse?

    GilaMonster (7/14/2009)


    GSquared (7/14/2009)


    Tropical beach for me, I think

    Niiiiiiice!

    I haven't ever been there. It is on my list of planned holiday destinations. Sometime.....

    Hey, Zanzibar is right next to JoBurg. Just...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

  • RE: Are the posted questions getting worse?

    Luke L (7/14/2009)


    GSquared (7/14/2009)


    Jan Van der Eecken (7/14/2009)


    Guys and Gals, you are freaking me out! I've been out of the office for not even six hours and there are already...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

  • RE: Are the posted questions getting worse?

    GilaMonster (7/14/2009)


    Grant Fritchey (7/14/2009)


    No kaboom.

    No boom today. Boom tomorrow. There's always a boom tomorrow.

    Did you know that in French "Avoir une boom" means "having a party"?:-P

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

  • RE: Are the posted questions getting worse?

    lmu92 (7/14/2009)


    GilaMonster (7/13/2009)


    Dave Ballantyne (7/13/2009)


    You can lead a horse to water but you cant force him to drink

    http://www.sqlservercentral.com/Forums/Topic751918-8-2.aspx?Update=1

    On second thoughts, I think I'm leaving that thread alone...

    tatcalltype ='null'

    Why.....

    He's back......

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

  • RE: Are the posted questions getting worse?

    Guys and Gals, you are freaking me out! I've been out of the office for not even six hours and there are already 38 new notifications in my inbox? Can...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

  • RE: Are the posted questions getting worse?

    Paul White (7/9/2009)


    Florian Reischl (7/9/2009)


    Augeninnendruckmessgeräteprüfungsgesetzverpflichtungsformularvordrucklayouterstellungsassistent

    *removes hat*

    However:

    select job_title = replace(N'Temporary part time libraries North West interlibrary loan business unit administration assistant', space(1), '')

    [font="Courier New"]job_title

    --------------------------------------------------------------------------------------

    TemporaryparttimelibrariesNorthWestinterlibraryloanbusinessunitadministrationassistant

    [/font]

    Easy :-P.

    Someone is bound to start a Leading...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

  • RE: Are the posted questions getting worse?

    Bruce W Cassidy (7/9/2009)


    Paul White (7/9/2009)


    Alvin Ramard (7/9/2009)


    Does anyone know why "abbreviated" is such a long word?

    🙂

    Unless you abbreviate it?

    abbr.

    [font="Verdana"]My personal motto is to never use a large word where...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

  • RE: Are the posted questions getting worse?

    Florian Reischl (7/9/2009)


    Jan Van der Eecken (7/9/2009)


    Florian Reischl (7/9/2009)


    Lynn Pettis (7/9/2009)


    Florian Reischl (7/9/2009)


    Augeninnendruckmessgeräteprüfungsgesetzverpflichtungsformularvordrucklayouterstellungsassistent

    Care to provide a translation?

    I feared this question... it's very hard kind of officialese.

    @chad-2: Right direction since you...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

  • RE: Are the posted questions getting worse?

    Florian Reischl (7/9/2009)


    Lynn Pettis (7/9/2009)


    Florian Reischl (7/9/2009)


    Augeninnendruckmessgeräteprüfungsgesetzverpflichtungsformularvordrucklayouterstellungsassistent

    Care to provide a translation?

    I feared this question... it's very hard kind of officialese.

    @chad-2: Right direction since you ordered the pizza.

    I did my best...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

  • RE: Are the posted questions getting worse?

    Paul White (7/8/2009)


    Jan Van der Eecken (7/8/2009)


    Donaudampfschifffahrtsgesellschaftskapitaenskajuetenschluesselloch

    The keyhole in the door of the Danube steamship company's captain's cabin. :w00t:

    10 out of 10 for this translation goes to Paul. Or was...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

  • RE: Are the posted questions getting worse?

    Lynn Pettis (7/8/2009)


    Jan Van der Eecken (7/8/2009)

    You guys just darn post too quickly, even if the likes of Barry and Steve are off on holiday, and Lynn has headed off...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

Viewing 15 posts - 511 through 525 (of 667 total)