Thanks anyway, you guys. @=)

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...

• This reply was modified 4 years, 10 months ago by  Brandie Tarvin.

SUM() has NEVER eliminated NULL values automatically for me. It...

• This reply was modified 4 years, 12 months ago by  Brandie Tarvin.

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:

            
January 16, 2020 at 6:34 pm
            
#3716080

            
            
                                                
        

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...

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...

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

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.

You don't have to test. I trust that two people telling me this is possible means it's probably possible.

Thank you both for your answers.

Those databases actually live on one of our database servers. When we initially did the install (this was one of the first 2012 servers we stood up), we thought they...

Not sure how well I'd get along with home working, and not sure how well it would do with my whooping 10Mbps down and 1 Mbps up internet.

As a...

So this is a side-by-side upgrade instead of an in-place (direct upgrade of current instance)?

Just verifying before I try to answer the question.

Because we are always looking and Allstate does let tech employees work from home (subject to certain caveats, depending on the division)… Careers @ Allstate.

Thanks, Grant.

We don't ever allow our Devs access to Production. What we do for them, however, is create a "production copy" database on a daily basis down to a...