What do you mean by "re-allocate the files"? Changing the name?

You haven't shown the other pages. Did you change the Database name on the first (General) page? That is what...

Yes it's possible. You can see if this thread helps.

For the purposes of the .Net tutorial, it seems like authentication type should be irrelevant.

I agree w/ Mr. Gale that using prefix "vw" for views and "trg" for triggers is a good, common, reasonable exception to the "don't prefix w/ object type" rule. And...

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 4 years, 8 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...