If it's not compressed, you could try zipping it first. But one way or another, the data has to get from A to B. Is there a reason why you...

Restore from a backup file instead.

Nice tweak, that's much cleaner. Thanks, Jonathan.

Maybe this?

DROP TABLE IF EXISTS #Data;

CREATE TABLE #Data
(
    CLNUM INT
   ,Model INT
   ,CLSTATUS CHAR(1)
   ,CLSTATDATE DATE
  ...

By this I mean it is out of order which it should be

Please take some time to think about people reading your post. We have no idea ... none at...

Here is a formatted version. Note that all of your

CAST ('YYYY-MM-DD' AS DATETIME)

statements can be simplified to 'YYYYMMDD'. As suggested above, this looks like homework to me.

CREATE...

You did exactly the right thing in adding the []. Your other fix also looks good, well done on resolving the issues!

Knowing when to use Python in SQL Server depends on the specific requirements and tasks you need to accomplish. Python can be used in various scenarios within SQL Server,...

Another option is adding a persisted, calculated column to one of the tables and indexing accordingly.

No, a single trigger can be used to cover multiple operations

CREATE TRIGGER ON ...

AFTER INSERT, UPDATE, DELETE

<trigger logic here>

I'd consider writing the output from these triggers into a custom 'MessageQueue' table and having a separate periodic process running which picks up unprocessed rows from this table, sends the...

Cool! I'd suggest you test/consider a couple of tweaks. The first, in particular, may improve performance, while the second is (IMO at least!) easier to read:

INSERT INTO...

• This reply was modified 2 years, 7 months ago by Phil Parkin. Reason: Fix query

OK, so you're going from SQL Server to Excel. That means you can use a...

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

OK, simply change my final SELECT:

WITH CustomerGroup
AS (SELECT *
    FROM
    (
        VALUES
  ...

Something like this?

DROP TABLE IF EXISTS #Customer;

CREATE TABLE #Customer
(
    Name VARCHAR(50) NOT NULL
   ,CustomerNumber INT NOT NULL
);

INSERT #Customer
(
    Name
...