You have a problem with a project file, so are asking how to fix MSSQL server files?

<head/desk> despair at spammer uselessness...

Yes, but you will need several clicks to do it...

In SSMS, navigate to your database.
Right-click, and, in the popup menu, go to Tasks, then "Generate Scripts".

You've got a field "TRANSACTION_TIME" as a date/time field - fair enough.  But also a field "TRANSACTION_DATE" as a varchar(900)?

Break the job into smaller steps.  Do a day (or an hour) at a time.  Script it so that it runs without intervention overnight.

If you change the 'FOR XML' part of your query to look like this:

FOR XML PATH (''), TYPE).value('.','varchar(max)')

you may find what you're looking for.

Those table names look horribly familiar...

What can you see in the windows error logs, or in the SQL Server installation logs (in C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log)?

CHECKSUM(NEWID()) is a way of generating a random number.  There are...issues with the T-SQL RAND function that can be illustrated with the following:

DECLARE @t...

What you're looking for might be something like:

ORDER BY CASE WHEN i <= 3 THEN 0 ELSE 1 END, CASE WHEN i <= 3 THEN...