Forum Replies Created

Viewing 15 posts - 7,006 through 7,020 (of 9,720 total)

  • RE: Today's Random Word!

    Country Bears Jamboree

    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 17, 2010 at 4:50 am

    #1251816

  • RE: format date within reporting services

    You haven't offended. I just wanted to make sure you knew the proper behavior so you wouldn't have problems in the future.

    On the other hand, the poster hasn't responded 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.

    November 16, 2010 at 9:40 am

    #1251428

  • RE: Today's Random Word!

    coal

    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 16, 2010 at 9:37 am

    #1251423

  • RE: GROUP BY PROBLEM IN SP

    brainblower13,

    Quick question, and please don't take this the wrong way.

    Have you ever written an INSERT statement before?

    Given the fact that you're trying to cram multiple rows into one SELECT...

    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 16, 2010 at 9:22 am

    #1251403

  • RE: Today's Random Word!

    I did archery (lousy archery) when I was a kid. Been thinking about getting back to it, but the local sports stores only carry hunting bows and I don't want...

    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 8:40 am

    #1250770

  • RE: SQL Server 2005 Maintainaince Plan excution fails

    EDIT: GAH. Wrong thread. Let me go back and re-read.

    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:49 am

    #1250686

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

    Linda 44925 (11/9/2010)

    I'm still confused by why the CTE method is better overall?

    A CTE is not necessarily better overall. I've seen CTEs that kill performance in certain circumstances. Sometimes...

    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:41 am

    #1250678

  • RE: Today's Random Word!

    Vacation.

    Over, alas. Back to the desk now.

    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:37 am

    #1250676

  • RE: format date within reporting services

    Ali Bajwa (11/5/2010)

    It is pretty simple to set the date format in SSRS if you know how to. Please follow my blog to resolve your issue:

    http://alibajwa.blogspot.com/

    Ali, be careful about...

    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:34 am

    #1250673

  • RE: Detective Stories - Changing the Case

    Thanks to everyone who's posted a response. I see I have a lot of testing to do.

    Someone mentioned removing extraneous spaces. In this particular case, there are no "extraneous" spaces....

    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:29 am

    #1250667

  • 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

Viewing 15 posts - 7,006 through 7,020 (of 9,720 total)