In general:

• Be consistent. A mediocre naming convention applied consistently is more user-friendly and less error-prone than a great convention applied only sporadically.
• Don't obsess -- don't spend too much...

It seems to model the real world. The additional complexity appears to be necessary.

You hit on one of the big shortcomings of the old approach -- a single user type...

By putting

 AND w4.MDMOVT = 'SKR'

into the WHERE clause, you effectively turned the LEFT JOIN into an inner join. Move it to the LEFT JOIN - i.e.,

            
October 5, 2021 at 9:05 pm
            
#3936846

            
            
                                                
        

That might give clues, but when people ask you to post execution plans, what they really want is to post the xml -- i.e., right click on the execution...

I don't know about prove, but ORMs often have a telltale signature.

I can easily recognize Entity Framework queries, which  alias tables as ExtentN, and alias parameters as @p__linq__N.  e.g.,

            
September 30, 2021 at 2:09 pm
            
#3935068

            
            
                                                
        

https://www.sqlservercentral.com/scripts/create-a-tally-function-fntally

A quick search for IBM DB2 equivalent of SQL Server STRING_AGG leads to the LISTAGG function in DB2.

I'm glad that video better clarified what I tried to demonstrate in my example, and that you now have a working solution.

STRING_SPLIT  actually was introduced in SQL 2016.

It's not an SSRS problem -- SSRS does pass multiple values in  a single parameter. If you run SQL Server profiler, you can...

• This reply was modified 3 years, 12 months ago by ratbak. Reason: Corrected to acknowledge a single-valued parameter does work in IN() clause

You can't pass a comma-delimited variable to an IN() clause.

You need to modify the stored procedure to convert the comma delimited list of phases to a table, & join your...

This was answered when you posted the question previously: https://www.sqlservercentral.com/forums/topic/add-values-from-a-table-to-an-another-table#post-3932190

You're describing an after update trigger.

Triggers use virtual/logical tables called deleted and inserted. "deleted" contains the data for all rows in the table affected by the transaction before the...

What type of application? MS Access by chance? I do find references to such a bug in Access -- e.g., https://social.msdn.microsoft.com/Forums/sqlserver/en-US/33a48549-aaa0-4301-a73c-3714ea41efb5/odbc-all-of-a-sudden-not-working-invalid-cursor-state?forum=sqldataaccess

If not, what version of ODBC?

Was there a recent Windows...

Is there an insert trigger on WEB_ORDERS? Cursor could be lurking there.

No, you don't have to. It will still fundamentally work (unless your specific application implements/relies on SQL 2019 features).

Higher-version features may simply not be available/used (e.g., cardinality estimator and query...