No it doesn't. Possibly because cursors are relatively lightweight objects in Oracle whereas they're very expensive in SQL Server,

One thing I'd do is set @ScriptLog immediately after the BEGIN TRY with details of the operation you're about to try - that way if it fails your log contains...

If there aren't any foreign keys (and logging tables like this rarely use them) just sp_rename the existing table to something else and recreate a new one. That way you...

The letters are just table and column aliases they could be FISH(CAT) and they'd still work fine.

You're resetting the XPath in your Apply statements and going back to the root of the XML (because the paths start with '/'). What you want to do is work...

If you're writing a program anyway, I'd just have it call your stored procedures and write the output wherever you want it.

I'd go with Lynn's suggestion of putting it in the ON clause of the join conditions, it's the cleanest syntax whilst avoiding accidentally converting an OUTER join into an INNER...

It's worth noting that, because of the dynamic nature of JavaScript, it's typical to assume a "missing" field and a null field are equivalent and most systems would expect there...

You don't need to query the JSON, you already have the value in your view, since you're using it to construct the JSON in the first place. 

I'd rather an EODAY function to solve that. And I guess an SODAY, which perhaps means FOMONTH should be SOMONTH. And let's have an SOWEEK, EOWEEK whilst we're at it....

And more code reviewing. Particularly because intellisense in...