When you say it is not returning a number, what is it returning?

Also, in your code, you are declaring @newID as a VARCHAR and then setting it to the result...

My only guess about it is readability and habit from other languages.

What I mean is some coding languages take a new line as being the end of that statement so...

A nice easy one for a Monday morning!  BUT a very important one to know about when working with AG's.

My method of experimenting is to get a database that has some sample data I can play with and just go at it.

We had a long blocking query a few...

My first step - check the logs.  Not JUST for the error you reported here, but the lines before and after that.  I suspect that there is a bunch of...

If you have a short list of languages and don't mind a bunch of SUM and CASE statements, you could get by using those

Such as:

DECLARE @tmpTbl TABLE
(
[USERname]...

Since this sounds like interview or homework (as others indicated), I think you are likely not to get 100% help.  You are asking a lot and giving very little.

Starting with...

Looking at that chunk of powershell, I don't see where it is looking for the name "Sheet1".  BUT if you did want to check for that, I would possibly have...

If you want to throw the query into a variable, you need to double up all of your quotes.  So all ' characters become ''.  All '' become ''''.  and...

You can force the parameters to have default values or you can hide some of them or you can adjust the number of rows and columns.  You could have 10...

Those are kind of my go-to's.

One thing that could be an interesting check would be how much data is being transmitted across that connection at the time the query is...

Execution plans would be my starting point.  make sure that the queries are all doing the same thing.

Also make sure all queries are getting the same results.

Then I'd check wait...

I could be mistaken, but I am 99% sure that the problem is that a QUEUE is not the same thing as a TABLE.

I just checked that queue on my...

I am not sure what the question is.  Are you wondering if I think SQL Server will work better or if SQL Server will need the same indexes as MySQL...

As a thought - if you can translate the symbols to numeric values, you could do it with some messy WHERE clause.  What I mean is something like:

            
October 27, 2020 at 10:09 pm
            
#3801900