Forum Replies Created

Viewing 15 posts - 7,381 through 7,395 (of 9,715 total)

  • RE: Need to split and combine some data in a query

    Kit G (9/27/2010)

    The part makes my head hurt is the joining the table to itself. Know of any articles about that which might help make my head hurt less?

    It's...

    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.

    September 27, 2010 at 11:26 am

    #1227852

  • RE: Today's Random Word!

    Because he can't afford all the others. @=) It's not just the dentist he has to pay, you know. Daughters expect kickbacks whilst they slumber.

    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.

    September 27, 2010 at 11:21 am

    #1227841

  • RE: Are the posted questions getting worse?

    I could look this up, I'm sure, but since we're on the topic of blogs, I'm going to be lazy (besides I can't look it up right now because if...

    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.

    September 27, 2010 at 11:19 am

    #1227840

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (9/27/2010)

    Put something out there, debate it and if you are wrong - take your lumps and make a correction.

    That's how I learned SQL. I tried to help out...

    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.

    September 27, 2010 at 11:15 am

    #1227836

  • RE: Cluster Error: MSDTC Resource

    AhHA! A coworker figured it out. The System log had a whole bunch of "Side by Side" errors, referring to access denied on several different .dlls and other files. Turns...

    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.

    September 27, 2010 at 9:04 am

    #1227760

  • RE: Cluster Error: MSDTC Resource

    I appreciate the advice. I do want to know what happened, though, so we can prevent it from occurring again.

    The last time we "lost" a resource on the cluster--the Agent...

    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.

    September 27, 2010 at 8:58 am

    #1227753

  • RE: Need to split and combine some data in a query

    Okay, here's redone code taking into account the event date & time columns being on the same row. However, you're making an assumption that Event 1's menu will always be...

    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.

    September 27, 2010 at 8:08 am

    #1227701

  • RE: Need to split and combine some data in a query

    Chris, your code doesn't do what he wants Menu1 and Menu2 to do.

    Also, you forgot to remove the # sign from your table name. Since he's a newbie and didn't...

    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.

    September 27, 2010 at 7:51 am

    #1227692

  • RE: Need to split and combine some data in a query

    Kit,

    Try using DatePart, DateAdd, and CharIndex in your code. It'll make your select statement a lot less messy.

    select Venue as VName,

    address1 as VAddr1,

    city + ', ' + state...

    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.

    September 27, 2010 at 6:11 am

    #1227634

  • RE: SQL Server 2005 Maintainaince Plan excution fails

    Glad I could help.

    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.

    September 27, 2010 at 5:14 am

    #1227617

  • RE: Problem with Linked Server to Excel

    Definitely thanks for posting the solution. I'd never thought of that one.

    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.

    September 27, 2010 at 5:13 am

    #1227615

  • RE: "Continuous" backup via VSS? Performance Issues?

    Glad we could help.

    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.

    September 27, 2010 at 5:12 am

    #1227612

  • RE: Today's Random Word!

    Mon-freakin'-day

    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.

    September 27, 2010 at 5:10 am

    #1227611

  • RE: Are the posted questions getting worse?

    Jeff Moden (9/26/2010)

    Heh... I knew the problem of asinine articles, bad blogs, cruddy code, dumb demonstrations, extreme egos, and flippant flawed followers was pretty bad before I started the research...

    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.

    September 27, 2010 at 5:09 am

    #1227610

  • RE: Are the posted questions getting worse?

    WayneS (9/26/2010)

    Brandie Tarvin (9/24/2010)

    Wow. I just found the most interesting article on VSS Writer and backups through it... Thought I'd share.

    Though I'm sure most of you have already seen it...

    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.

    September 27, 2010 at 5:06 am

    #1227609

Viewing 15 posts - 7,381 through 7,395 (of 9,715 total)