I can't say I have ever used RIGHT JOIN. I think it is only in the language for completeness.

Are you sure? I struggle to understand cursors ate the best of times, but I think the set based solution...

Given the OP stated "I run a script that brings the data that was modified in the last 24 hours from the 3rd party system" I assumed that the data...

Acceptable, perhaps.  But can you name any major RDBMS that...

I run a script that brings the data that was modified in the last 24 hours from the 3rd party system.

This table contains about 500,000 records for each day.

Then...

Where do you want to do the process? In Excel or in SQL Server?

It is the tradition on this forum that the poster of the question supplies the data in...

CREATE TABLE testvisit (
    primarydoc varchar(50),
    client_id int,
    visitdoc varchar(50),
    doc_id int,
   ...

@jonathan-2 AC Roberts or anyone, do you know if there is a chance to ORDER BY in alphabetical order whatever is a column? Right now they are in a...

@jonathan-2 AC Roberts or anyone, do you know if there is a chance to ORDER BY in alphabetical order whatever is a column? Right now they are in a...

Acceptable, perhaps.  But can you name any major RDBMS that uses singular...

reduce the length to

The numbers should begin with 11. The minimum length of the number should be 10 The maximum length of the number should be 15 Need...

• This reply was modified 3 years, 6 months ago by Jonathan AC Roberts. Reason: zeros after 11

Acceptable, perhaps.  But can you name any major RDBMS that uses singular table names...

DECLARE  @RowsToGenerate as int = 10000000
SELECT DISTINCT TOP(@RowsToGenerate)  x.Num
  FROM (SELECT LEFT('11' + CONVERT(varchar,(CONVERT(bigint,ABS(CHECKSUM(NEWID()))))) + CONVERT(varchar,(CONVERT(bigint,ABS(CHECKSUM(NEWID()))))) ,10+T.RandNum) Num
      ...

Hubert Blaine Wolfeschlegelsteinhausenbergerdorff Sr. won't even be getting his abbreviated name on your database.

Definitely remove the word "Table" from the end of your table names. You'll also have Joe Celko coming in and giving you a hard time if you don't!

I believe it's...