Forum Replies Created

Viewing 15 posts - 7,021 through 7,035 (of 9,725 total)

  • RE: Detective Stories - Changing the Case

    Carl Federl (10/18/2010)

    Perhaps I am missing something but what is wrong with a solution that has no cursors, whiles or UDFs ?

    Maybe I'm misreading your solution, but it doesn't seem...

    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.

    November 15, 2010 at 6:24 am

    #1250662

  • RE: Detective Stories - Changing the Case

    Jan Van der Eecken (10/18/2010)

    Hi Brandie,

    I guess the final update back will fail on a database with a case sensitive collation. Shouldn't it rather read:

    Update idf

    Set Location = mt1.Location

    from dbo.Import_Data_Filter...

    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.

    November 15, 2010 at 6:22 am

    #1250659

  • RE: code to select highest in each of several catagories

    CELKO (11/4/2010)

    Columns are nothing like fields.

    Not necessarily true.

    Talk to a business user once in a while (someone who's used Lotus or Excel or Access) and you will find they...

    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.

    November 4, 2010 at 11:39 am

    #1246727

  • RE: Are the posted questions getting worse?

    And if she chooses not to, a new topic of discussion. I'll start.

    TOPIC: Things you should never tell your parents

    How those footprints *really* got on the ceiling.

    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.

    November 4, 2010 at 11:24 am

    #1246712

  • RE: Where are you?

    pitvax (11/4/2010)

    ... and I am writing from Czech Republic.

    Pit Vax

    Welcome to the group! It's nice to meet people from the international SQL Community.

    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.

    November 4, 2010 at 10:26 am

    #1246664

  • RE: Today's Random Word!

    <headdesk><headdesk>

    New WOTD: groan

    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.

    November 4, 2010 at 7:08 am

    #1246507

  • RE: Today's Random Word!

    Chris Morris-439714 (11/4/2010)

    Brandie Tarvin (11/4/2010)

    Thor

    Do you know the age-old joke about Thor?

    Depends. If you're talking about the Thorsday joke, my father tells it all to frequently. If you're not, do...

    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.

    November 4, 2010 at 6:53 am

    #1246500

  • RE: Today's Random Word!

    Thor

    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.

    November 4, 2010 at 4:40 am

    #1246445

  • RE: Today's Random Word!

    CirquedeSQLeil (11/3/2010)

    crookj (11/3/2010)

    CirquedeSQLeil (11/3/2010)

    Cobra

    GI Joe 😉

    A real American Hero.

    And knowing is half the battle.

    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.

    November 3, 2010 at 8:59 am

    #1246063

  • RE: Today's Random Word!

    Yes.

    @=)

    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.

    November 3, 2010 at 6:07 am

    #1245936

  • RE: Are the posted questions getting worse?

    GilaMonster (11/3/2010)

    I'm running SQL 2008 and SQL 2008 R2 (developer edition both) on my desktop. R2 replaces 2008's management studio and BoL, but no problems on the DB engine.

    I would...

    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.

    November 3, 2010 at 5:27 am

    #1245920

  • RE: Today's Random Word!

    morning.

    urgh.

    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.

    November 3, 2010 at 4:19 am

    #1245894

  • RE: Are the posted questions getting worse?

    Just got me a Dev copy of R2 and am uninstalling the regular 2k8 eval copy from my laptop now. Gonna play, gonna play.

    I'm debating on getting a Dev...

    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.

    November 3, 2010 at 4:17 am

    #1245893

  • RE: Are the posted questions getting worse?

    GilaMonster (11/2/2010)

    WayneS (11/2/2010)

    Date field stored as varchar(8000) - what kinds of problems do you see coming up from this OP?

    8000 characters for a date? I could store an entire calendar...

    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.

    November 2, 2010 at 11:31 am

    #1245578

  • RE: Query does not return data

    Even a convert will fail if someone has put non-date data in your column. You should probably do an ISDate() check on the column to weed out non date values...

    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.

    November 2, 2010 at 11:28 am

    #1245575

Viewing 15 posts - 7,021 through 7,035 (of 9,725 total)