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

This question is strikingly similar to this one.

Perhaps the responses you received there were not to your liking? You did not even have the courtesy to respond to the...

Whoever asked you to do this needs to...

This possibly means that there is a 32-bit version of the driver installed on the server but not a 64-bit version.

I suggest you get out of the habit of writing = NULL. Instead, write IS NULL. NOT is very useful, do not discard it!