Viewing 15 posts - 316 through 330 (of 9,731 total)
Knock, knock. Anyone home?
Or are we avoiding congregating on The Thread so we don't infect each other through the interwebs?
March 17, 2020 at 10:47 am
I've never been able to get my hands on a physical server. Remote into one, sure. But actually touch and play with one?
@Sob. Never!
March 16, 2020 at 12:02 pm
Was there an update to SSC recently?
The "last page" bug is back. When posts are under a certain number, the email link sends me to the page before and when...
March 15, 2020 at 9:50 am
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....
March 15, 2020 at 9:48 am
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...
March 15, 2020 at 9:47 am
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...
March 13, 2020 at 3:59 pm
Disneyland closed down. And I think Disney World is following suit.
March 13, 2020 at 3:10 pm
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...
March 12, 2020 at 6:23 pm
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...
March 4, 2020 at 9:45 am
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...
March 4, 2020 at 9:40 am
Thanks anyway, you guys. @=)
March 3, 2020 at 3:18 pm
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...
March 3, 2020 at 3:07 pm
Why are you doing the
ISNULL()check? TheSUM()will eliminate NULL values automatically. Are you trying to eliminate the warning?
SUM() has NEVER eliminated NULL values automatically for me. It...
January 17, 2020 at 12:17 pm
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
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...
January 16, 2020 at 11:51 am
Viewing 15 posts - 316 through 330 (of 9,731 total)