Forum Replies Created

Viewing 15 posts - 316 through 330 (of 9,728 total)

  • Reply To: Are the posted questions getting worse?

    Jeff Moden wrote:

    Brandie Tarvin wrote:

    So an international academic writers conference (ICFA) that I usually am invited to as a fiction writer, and forgot to accept the invite last October, has been cancelled....

    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.

    March 15, 2020 at 9:48 am

    #3734504

  • Reply To: Are the posted questions getting worse?

    Speaking as an advocate for "don't get me sick too," you should be working from home whether you have just a cold or flu or have the COVID19 nasty.

    I really...

    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.

    March 15, 2020 at 9:47 am

    #3734503

  • Reply To: Are the posted questions getting worse?

    My parents recently moved close to me. Now I have to be extra careful because they have enough additional health conditions that COVID19 probably will be fatal if they get...

    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.

    March 13, 2020 at 3:59 pm

    #3734117

  • Reply To: Are the posted questions getting worse?

    Disneyland closed down. And I think Disney World is following suit.

    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.

    March 13, 2020 at 3:10 pm

    #3734089

  • Reply To: Are the posted questions getting worse?

    So an international academic writers conference (ICFA) that I usually am invited to as a fiction writer, and forgot to accept the invite last October, has been cancelled. I haven'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.

    March 12, 2020 at 6:23 pm

    #3733728

  • Reply To: Finding specific file with dynamic date

    Jeffrey Williams wrote:

    If you have more than 1 file that matches the date string - I assume you want only the latest file that is available.  You also don't need 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.

    March 4, 2020 at 9:45 am

    #3730800

  • Reply To: Finding specific file with dynamic date

    Some files we're importing into SQL. Some files are data ported out of SQL that we need to add SFTP log files to. And some files we're doing other things...

    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.

    March 4, 2020 at 9:40 am

    #3730796

  • Reply To: Finding specific file with dynamic date

    Thanks anyway, you guys. @=)

    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.

    March 3, 2020 at 3:18 pm

    #3730595

  • Reply To: Finding specific file with dynamic date

    Well, I feel kind of silly. I have spent 2 weeks trying to figure this out before I finally posted here. Then after posting, went back to searching and finally...

    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.

    March 3, 2020 at 3:07 pm

    #3730581

  • Reply To: Calculating totals based on a column flag

    Why are you doing the ISNULL() check?  The SUM() will eliminate NULL values automatically.  Are you trying to eliminate the warning?

    SUM() has NEVER eliminated NULL values automatically for me. 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.

    January 17, 2020 at 12:17 pm

    #3716267

  • Reply To: Calculating totals based on a column flag

    ScottPletcher wrote:

    I posted a simplified query if you don't need to list/modify the individual values.  To just subtract out the excluded values, you don't really need the CROSS APPLY:

    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.

    January 16, 2020 at 6:34 pm

    #3716080

  • Reply To: Calculating totals based on a column flag

    The ABS(CAST(BE.Buck1 AS tinyint) - 1) doesn't work for me. It is zeroing out the flag that tells me whether or not to include the bucket.

    Here's what I've come up...

    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.

    January 16, 2020 at 11:51 am

    #3715936

  • Reply To: Calculating totals based on a column flag

    Assumption #1, I do have a join table that I'm working off of and forgot to include.

    Assumption #2, I can't (and don't want to) zero out the individual buckets. I...

    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.

    January 14, 2020 at 9:45 pm

    #3715435

  • Reply To: Uninstall SQL without uninstalling SSRS

    crow1969 wrote:

    Heh.  I think you trust me more than my boss does 😉

    Well the more I thought about it after I posted, the more I realized that if SSRS can...

    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.

    December 11, 2019 at 3:09 pm

    #3707001

  • Reply To: Migrating DB encrypted by master key

    I did not know about the encryption algorithm changing.

    This might mean the need to unencrypt the database before moving it and then re-encrypting it after the move.

    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.

    December 11, 2019 at 1:25 pm

    #3706913

    • Viewing 15 posts - 316 through 330 (of 9,728 total)