As I can't see your tables...

As you have not provided any DDL, I had to make a guess.

drop table if exists #x;

create table #x
(
    Ident varchar(20)
  , Name...

As you've not even provided your query, I'm not sure how you expect anyone to help you change it!

Also, this is a presentation issue. SSRS will easily do this for...

You could use SSDT to run a schema compare. This can be an automated process, if required.

I think you may have misunderstood me. Look at these columns, for example:

,Entry_summary_date

,Supplier

,Destination

,Part_num

,Manuf_id

,HTS_num

How can anyone look at this...

i should  get  a few thousand rows back, but when i try pull in Duty Rates, i get hundreds of thousands. Thoughts?

Thought #1: Your join is not working as you...

This post appears to be a duplicate of

https://www.sqlservercentral.com/forums/topic/mail-when-value-of-field-or-paramater

Which already contains suggestions (and some outstanding questions) as to how you might approach this.

the upgrade has created some database schema in the back end

Please explain what you mean by this. A new database schema should not do anything bad, per se.

That requirement looks suspect to me.

Do (a) and (b) both have to be true (AND), or is it a case of one or the other (OR)?

One benefit I see is to do with vertical alignment.

SELECT col1
      ,LongCol2
      ,LongerCol3
    ...

My testing agrees with yours ... line 1 appears to be the line just before CREATE PROC

PolicyType is Pascal case, not camel case, which would be policyType.

I guess I'm lucky: I've been reading code without underscores for so long that I find it just as easy...

You would use TINYINT with 1 or 0 so you can do a SUM aggregate.  If you used Y/N, couldn't you get the same result by using some function to...

Not tested, but the syntax will be more like this:

(SafetyBaseline ==  FALSE  && RegulationBaseline ==  FALSE  && EnvironmentSafetyBaseline ==  FALSE  && EnvironmentSecurityBaseline ==  FALSE) ? IsActive = False: IsActive =...

Just to be sure, it wasn't meant as any kind of slam for missing something, Phil.  I absolutely thought it excellent emphasis on a problem that would eat...