Forum Replies Created

Viewing 15 posts - 6,526 through 6,540 (of 9,725 total)

  • RE: Accidentally deleted a Table ?? Can I recover ??

    Ninja's_RGR'us (2/10/2011)


    kasaranenikiran-725528 (2/10/2011)


    This was DEV envoronment . ANd I have already revised the Backup strategy as Full Backup once a week. I will also look in to putting it in...

    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?

    CirquedeSQLeil (2/9/2011)


    Monthly meeting note.

    This month we have Randy knight presenting on Oracle and SQL and helping to make them play nice together.

    More info here.

    Oh, that sounds interesting. I'll have 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 the posted questions getting worse?

    GSquared (2/9/2011)


    Kit G (2/9/2011)


    To those Threadzians (and everyone else) getting hit by the latest winter storm, stay warm and safe.

    And to those in Florida who can't deal with frigid, sub-70...

    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: Help with a query

    So we can see what you've done, please post your solution to your other problem.

    There are several ways to solve your second problem. Because we're trying to help you learn...

    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: To get the Max value from one column with case statement without using any aggregate functions

    Koen, don't bait. You know better.

    nadabadan, please remember this is a professional forum. You may not realize this, but your written word choices come off as defensive and argumentative, without...

    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: Create temp Tbale using SSIS

    The one sure way to avoid that is to use an IF EXISTS statement before creating your temp table. But you've already got a version of that. Did you remove...

    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: Create temp Tbale using SSIS

    Post your new code. Include details on which code is in which task and tell us which of the tasks is failing.

    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: Create temp Tbale using SSIS

    Remove your variable declarations. Remove the "Set @cmd1 = ' " bits and the trailing single quotes after the T-SQL. Remove the Execute statements.

    Then run the code.

    As Koen said, there'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.

  • RE: Create temp Tbale using SSIS

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


    Furthermore, it is possible that the statement within the EXEC is executed under a different scope, so your temp table is likely already destroyed before the next statement...

    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?

    Gus's suggestion has me wondering if a book like that would actually sell.

    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: Create temp Tbale using SSIS

    Between @Cmd2 and @Cmd3, how are you populating the temp table?

    Is it a separate task after executing @Cmd2 and before executing @Cmd3? Or are you doing it all in...

    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!

    CirquedeSQLeil (2/9/2011)


    Peter Trast (2/9/2011)


    CirquedeSQLeil (2/9/2011)


    Histogram

    Histamine

    Histayours

    OK, how about word morph? Each WOTD a morph of the last?

    That game works well here.

    And we've done it several times before. And will likely 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.

  • RE: Today's Random Word!

    CirquedeSQLeil (2/9/2011)


    Histogram

    Diagram

    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?

    Actually, I refer to CASE as a statement all the time. Call me lazy. I think I picked up the habit from the programming languages I learned in HS and...

    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?

    Jan Van der Eecken (2/9/2011)


    You know, I read through that whole thread, and somewhere mid-way I started wondering whether nadabadan himself wasn't actually the interviewer. I guess I am certainly...

    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,526 through 6,540 (of 9,725 total)