Maybe a good way could be an UPDATE statement

update t
set flag = case when v.row_count=1 then 'ANY_EMPTY'
          ...

In the situation where Sum([QTY]) returns the correct the number, AVG(OH) or MAX(OH) ought to return only 1 SKU

At a minimum it's missing a comma at the end of the first line.  Is it necessary to nest SELECT statements within the SELECT list as you've done?  It seems...

Yup, I was one of the 'most people' crowd, thanks for alerting me to that, Jeff. Always good to be aware of these extra possibilities. It was also only...

The DIY way could be to...

Concat_ws was originally in MySQL then the other db's borrowed it iirc.  The big news for me is .NET 6 which I'm really liking a lot because it nicely untangles...

CONCAT_WS() "concat with separator" ignores the nulls

select concat_ws(' | ', t.Col1, t.Col2, t.Col3) [output]
from #t t;

The date could be converted without using string functions.  Also, the WHERE clause might be a more appropriate place to filter the rows.  Maybe something this

declare @UPSBatchInvNot...

Why would you want to avoid JOIN?  Maybe use IN but there's no benefit afaik and it might actually be slower

select partc
from #partsc
where VerificationHash in(select VerificationHash
 ...

What is the primary key of the target table?  With Scenario4 you're inserting a new row which would duplicate (or more?) the TaskId.  Once the TaskId is non-unique then further...

Not sure what you mean here. If you're...

So a billion flies cannot be wrong?  Imo attempting to derive wisdom from overdefined equations could turn out to be counterproductive

The "solution" is the following:

i had another talk with the user, we discussed the relevancy of the individual columns

• C was the most important out of a,b,c
• C, as...

From a design perspective why does the table need to know all the information about how characters are extracted from another column?  It seems like whatever is inserting the row...

drop table if exists Report_Es;
go
create table Report_Es(
  ola1      int,
  ola2      int,
  ola3  ...