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

This was new news to me.  We're using Azure SQL and I confirmed it works (tested at Compatibility Level 150).  Since the input argument "string is an expression of any...

The link for the splitter I think is in this article.  For id=7 and ItemNumber=3 the (split) Item equals 'ccc ccccc' which is maybe space delimited and needs further...

Yeah situations like this happen all the time tho.  It seems there are unmodeled relationships in the data.  Also, right away I would try to find out if you're supposed...

Hi there.  Using BETWEEN and DATETIME is really not recommended.  Jeff pointed this out and I listened but didn't change the code.  Suspicious things 1) the datetime range doesn't seem...

Hi Rod, cheers.  Not sure about pro tools but if you're up for rolling your own you could try .NET and System.IO

https://docs.microsoft.com/en-us/troubleshoot/dotnet/csharp/create-file-compare

https://stackoverflow.com/questions/1358510/how-to-compare-2-files-fast-using-net

It's a school assignment?  There are seemingly quite a few steps to accomplish.  What's the question?

How to plan data types?  It's simple: use the minimum necessary size given your anticipated precision requirements.  Aside: there are edge cases having to do with all sorts of exceptions...

Great insights as always Jeff.  Ha, yes I do remember those days.  No spring chicken here.  The first number in my age is a 5.

3 ways to convert an integer...