Here's a new one.

SELECT <primary key>, <other fields>
FROM Table_Stage

INTERSECT

SELECT <primary key>, <other fields> /*  all fields from Table_Prod  */
FROM...

Also using the same expression in both the PARTITION BY and ORDER BY clauses of an OVER() clause.

NOLOCK

Using DISTINCT with UNION or GROUP BY.

Drew

The problem appears to be here:
    SQLCMD.CommandText = "IF OBJECT_ID(N'dbo.WomenStartListDay1', N'U')

IF requires a conditional expression and OBJECT_ID(...) does...

Furthermore, GETDATE() returns DATETIME, so converting from DATETIME to DATETIME is an identity operation.

Drew

This query is too simple to improve the performance on.  You have none of the major factors that contribute to poor performance, so there is no way to reduce or...

What have you tried?  HINT: ROW_NUMBER() is probably the simplest approach.

Drew