I took "I need to update my sql script...

There is no question!

Your suggested query should use UNION ALL rather than UNION (which applies an unwanted (in this case) 'DISTINCT' to the results returned). Only 'read' access is required for this query.

However,...

M can do it, but if you have hundreds of thousands of rows of data, it will take a while.

Are you just looking for help with the necessary M syntax?

Does the data come from a single database? Performance-wise, I'd suggest doing as much of the 'heavy-lifting', in terms of ETL and combining result sets, using the SQL Server database...

It is impossible. Remove UNION from the script and...

OK ... but what is your question?

If you want someone to attempt a coded solution, please provide the sample data in a consumable format. With > 3,000 points, I'm sure you know what that means.

Also, it...

It really is great when people are polite, enthusiastic and post back with gratitude. Pleade keep on posting and learning.

I am Phil, just like you told me so. But i wouldn't like to "repeat" the company name. Is this the only way? Can't i write Company instead of...

• This reply was modified 3 years, 3 months ago by Phil Parkin.

This, maybe? (Assuming you are using the table aliases I suggested)

CONCAT(cd.Serie, ' - ', 'S&A', ' - ',ld.CCustoCBL) AS JoinCC

Ah, please ignore my first answer, which would add a column to a physical table. If all you want to do is add another column to the query, it's as...

Here is some code which demonstrates this. Notice that I have changed your constraint name to follow the convention DF_[tablename]_[columnname], because constraint names must be unique (within schema).

            
July 3, 2022 at 12:22 pm
            
#4058123

            
            
                                                
        

That is almost correct. Just need to shuffle things round a...

If you provide your sample data in a more accessible form, like this, you will probably get more responses:

DROP TABLE IF EXISTS #Transaction;

CREATE TABLE #Transaction(Transaction_Id INT, Date_Transaction...