Forum Replies Created

Viewing 15 posts - 6,991 through 7,005 (of 9,715 total)

  • RE: Database model for villa renting systems?

    didier.boelens (11/18/2010)

    I use Julian Dates to obtain an integer value which makes the query faster...

    And that speed isn't negated by the functions used to switch your start and end dates...

    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 18, 2010 at 8:42 am

    #1252574

  • RE: Database model for villa renting systems?

    Why are Julian dates necessary?

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

    #1252520

  • RE: Today's Random Word!

    WOTD: Car

    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 18, 2010 at 7:25 am

    #1252500

  • RE: Are the posted questions getting worse?

    For our chapter, the sponsor pays expenses directly. But then again, we have Brian Knight's company sponsoring most of our meetings, so we are kind of cheating. Occasionally the staffing...

    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 18, 2010 at 7:23 am

    #1252499

  • RE: Database model for villa renting systems?

    didier.boelens (11/18/2010)

    Would anyone have such a model, together with the optimized query?

    You have to be careful with questions like that. Database models are not a 1 Size Fits All thing....

    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 18, 2010 at 7:18 am

    #1252494

  • RE: Today's Random Word!

    bcsims 90437 (11/17/2010)

    Brandie Tarvin (11/17/2010)

    Country Bears Jamboree

    DISNEYLAND!!!! Happiest pace on earth, and just thinking of it made me smile.

    Disney World!

    (That's what they call it in my neck o' the...

    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 11:01 am

    #1252032

  • RE: Are the posted questions getting worse?

    Alvin Ramard (11/17/2010)

    Brandie Tarvin (11/17/2010)

    Stefan Krzywicki (11/17/2010)

    I need to pick one blog to tart up as once I've done it on one of them, the others will be easier.

    Steve,

    I'd...

    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 9:43 am

    #1251969

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (11/17/2010)

    I need to pick one blog to tart up as once I've done it on one of them, the others will be easier.

    Steve,

    I'd like to report Stefan'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.

    November 17, 2010 at 9:23 am

    #1251961

  • RE: Get the Current Date

    As I've never used Current_Timestamp, I did not know it was unsupported in SSIS expressions. Thanks for the update, Stefan.

    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 9:19 am

    #1251955

  • RE: Today's Random Word!

    language

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

    #1251874

  • 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

Viewing 15 posts - 6,991 through 7,005 (of 9,715 total)