Thanks, I think every time I try to get something done in Azure, I learn something. Between the complexity and pace of change, I'm always learning something.

Thanks, Frank. Glad you enjoy them

I enable it rarely. We do use it for deployments from Redgate products, but overall I think I worry about accidentally doing something strange in a script. Also, since I...

You are welcome

I like Matt's solution. Once you decide on ordering and know what item you want, row_number() gives you a value that you can use in the WHERE clause.

Here are versions and features supported: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_SQLServer.html#SQLServer.Concepts.General.FeatureSupport

Unsupported items: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_SQLServer.html#SQLServer.Concepts.General.FeatureNonSupport

In general, when I looked at this before, and you are like a dbowner for a database(s), but not exactly. There are...

You are very welcome

That's the report, but I have to find the issue in Github for tracking. Didn't see one, or someone named it strangely. I just added a new one.

Thought there was an issue for this, Luis, but don't see one in the various code style items. Added this.

Grant is correct. You're trying to think about this incorrectly, according to what MS has built.

Azure SQL DB <> SQL Server database on premise

In fact, the version of Azure SQL...

A bit more code to check

SELECT a.PharmNo, a.ClaimNo, a.ClaimDate, b.PharmNo, b.ClaimNo, b.ClaimDate
FROM Claim AS a
    INNER JOIN Claim AS b ON a.PharmNo = b.PharmNo...

I agree with Grant, though I'll say that pursuing the certification gives you a chance to learn, and you can document that. You can make notes, blog, write test queries...

I think I missed this because if you click a menu item, it does go away. I would think if you click menu, that's the most obvious choice, but maybe...

No idea if that's available as some event. I think this is one reason people start to hate JS, and we get some weird designs because there are so many...

Thank you and hope you stop and enjoy something today