This line in the WHERE clause

AND (hrxoreturn.returndate >= '2023-02-14 00:00:00' and hrxoreturn.returndate <= '2023-02-14 23:59:00')

changes your RIGHT JOIN to an INNER JOIN.  If you move the line to your JOIN...

Have a look into the DATEPART function.  That should point you in the right direction.

I'm glad to hear that you've found a solution.  As far as synchronising data during migrations, replication or log-shipping (one way or the other) are probably the most straightforward options. ...

If you have access to the log files taken using Commvault, why can't you use some homegrown method to restore those to your target database?  We use the OH scripts...

There appears to be a typo in the question in that it asks for "what command" but there are apparently two correct answers.  The answers have tick boxes which suggests...

Guess how my f$%^ing Saturday has started too.

Now it's Friday.  Mine started especially early too with a callout 45 minutes...

Cove

I can't speak about becoming full developers but we're currently in the process of migrating to AWS.  As part of this, I've found myself building Windows Failover Clusters and working...

One, please, always, despite this being a technical question, talk to someone in legal at your organization after you decide on a path forward.

Two, I've been studying this for...

.

Heh... mine has started off with a bit of a "well that sucks" factor.  Whole new time-keeping system where they want me to categorize virtually every aspect of...

• This reply was modified 2 years, 11 months ago by  Neil Burton.

It's a big year for us next year because we're moving into AWS.  The initial migration will be like-for-like to maintain consistency but there's going to be the opportunity to...

One of my domain passwords expired yesterday so I asked the service desk to reset it for me.  I then spent half an hour trying to create a password that...

When you say the PDWEDT column is numeric, how exactly is it stored?  Your code returns '2021-11-28 hh:mm:ss.nnn' as  last Sunday with the precise time dependent on when the code was...