Forum Replies Created

Viewing 15 posts - 6,631 through 6,645 (of 9,715 total)

  • RE: UPDATE using a self-join

    CELKO (2/1/2011)


    ACCESS had two camps -- the engine and the front end -- that did not like each other. The company policy was that if the front end could not...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: I cannot understand these codes

    Craig Farrell (2/1/2011)


    npatel.bi (2/1/2011)


    DATEADD("m", DATEDIFF("m", 0, Date) -4, +2))

    When I run this query on 29th January it gaves me 10/01/2010.

    When I run it right now on 02/01/2010 its giving...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: I cannot understand these codes

    Craig Farrell (2/1/2011)


    Brandie Tarvin (2/1/2011)


    Craig, you've got me confused now. What part of that equation changes the days from the 1st to the 3rd?

    The +2 part at the end. ...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Are the posted questions getting worse?

    Koen (da-zero) (2/2/2011)


    Koen (da-zero) (2/2/2011)


    This is a weird thread:

    http://www.sqlservercentral.com/Forums/Topic1057267-391-1.aspx

    Ugh. If someone else wants to skip in on this thread.

    Apparently English doesn't work...

    I added my two cents. We'll see if that...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Updateparent table such that the values in child should also update

    Apparently you are not understanding the responses you are being given to your question. Several people have given you other options than the two you don't want. The primary option...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Are the posted questions getting worse?

    Tom.Thomson (2/1/2011)


    Trey Staker (2/1/2011)


    Brandie Tarvin (2/1/2011)


    Never fear, Threadzians. Apparently people are working to keep the internet from being blocked by politicos. See this Yahoo! News item for more details.

    That's cool...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Are the posted questions getting worse?

    Never fear, Threadzians. Apparently people are working to keep the internet from being blocked by politicos. See this Yahoo! News item for more details.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: UPDATE using a self-join

    GSquared (2/1/2011)


    Stefan Krzywicki (2/1/2011)


    Brandie Tarvin (2/1/2011)


    CELKO (1/31/2011)


    Successful projects start on lesser SQLs (even ACCESS ) then have to move to DB2, Oracle, Teradata or whatever.

    Including Access? What other lesser SQLs...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: UPDATE using a self-join

    CELKO (1/31/2011)


    Actually, INSERT and UPDATE are single table operations, while MERGE requires a source and target.

    I haven't moved up to SQL 2k8 yet, so haven't had a chance to...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Today's Random Word!

    Tom.Thomson (2/1/2011)


    Peter Trast (1/31/2011)


    Brandie Tarvin (1/31/2011)


    WOTD: Tea

    "A drink with jam and bread"

    Dough

    "And that brings us back to..."

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Are you a "hunt and pecker" or a "typist"?

    Typist. 99 WPM. And yes, those touch screens drive me nuts. Can't feel the key boundaries and there's not enough space between virtual keys for me to hit the correct...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: I cannot understand these codes

    Craig, you've got me confused now. What part of that equation changes the days from the 1st to the 3rd?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Are the posted questions getting worse?

    GilaMonster (1/31/2011)


    Brandie Tarvin (1/31/2011)


    If the poster said that, I don't blame you for slapping down. The question is, how diplomatic were you?

    He was pretty diplomatic about it. Far more diplomatic...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Are the posted questions getting worse?

    If the poster said that, I don't blame you for slapping down. The question is, how diplomatic were you?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: reset sa password

    GilaMonster (1/31/2011)


    Brandie Tarvin (1/31/2011)


    Box Admin and SQL Server admin are not the same thing.

    They are if SQL is running in single user mode. Challenge appears to be to find what...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 15 posts - 6,631 through 6,645 (of 9,715 total)