To a degree, the difference between ON & WHERE, can be, but isn't entirely, syntactic sugar. However, what I say is, for clarity sake, put filter criteria in the...

I prefer wrapping the code in a check for primary - instead of adding a step.  When you add a step and fail - you also have to set that...

Thank you Jeffrey , like your last comment, looks like you used  dense_rank() instead of rank(). this made the difference.

"RANK and DENSE_RANK will assign the grades the same rank...

Here is an example:

Declare @sampleData Table ([Day] date, [Hour] char(8));
 Insert Into @sampleData (Day, Hour)
 Values ('2022-03-30', '12:48:36')
      , ('2022-03-30', '12:48:36')
 ...

Verify the hour column doesn't contain additional data.  If you can provide test data in the form of create and insert statements I can provide a working example.

Instead of trying to recreate that expression - you can and should use RANK() or DENSE_RANK().

Not exactly - I would create shared storage and present that storage to every node in the cluster and allow it to failover to any available node.  If you assign...

There is another option available - you can also use a cloud witness.

With that said, for a 2-node cluster I would use the same thing regardless of type of cluster. ...

It looks like you are trying to use a stored procedure as a function - which is generally not a good idea.  With that said - there is nothing that...

It would be much better for you to go back to the sender and have them send that data in an unambiguous format.  I get that some senders refuse -...

Although this is an option - don't do this. ...

@JeffreyWilliams Thank you for your input. Would you say, definning primary keys for each row would be the quickest way to ensure uniqueness or no duplicate values being imported?

I...

And if you don't like mixing cross join and cross apply - or using the table variable, you can embed the column mapping into the query as follows:

Jeffrey Williams

“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll
How to post questions to get better answers faster

Managing Transaction Logs