Getting sp_executesql to work is pretty easy.

DECLARE @sql NVARCHAR(MAX)
SELECT @sql = '<insert dynamic SQL here>'
EXEC sp_executesql @sql

The only thing that makes your query a bit more tricky...

Quick google of this brought me to this link:

https://stackoverflow.com/questions/13245364/ms-sql-server-pivot-table-with-subquery-in-column-clause

Which basically says you cannot do it because SQL is expecting a static number of columns to be returned, but a semi-dynamic...

I agree with Grant's first statement - that is asking for trouble and can be a scary practice... and if you read his signature, he is The Scary DBA!

Why it...

NOTE - I am not an LDAP expert, but the following is my understanding of how the authentication chain works.

I think this was answered previously and my answer was that...

My opinion - test it out.

Upgrading from 2008 R2 to 2019 MAY require upgrading your OS as well and, if I remember right, 2019 doesn't support 2008 compatibility  mode.

What I...

I wasn't sure if the Browser service was required for the default instance on port 1433 or not, but I generally start the browser service as soon as I install...

As I said multiple times - Firewall.  Just because port A is open in the firewall and you can connect to SQL instance B doesn't mean that port C is...

First, I think you would likely get better support on a MySQL forum than a SQL Server forum.

Second, my understanding of MySQL is that it keeps the temporary tables in...

I think there are multiple approaches to this, but if it was me, I would start by trying to define the problem you are trying to solve rather than starting...

Jeff - My GUESS is that it was an implicit conversion due to the division by int.  I expect that Length is a CHAR or VARCHAR datatype, but holds FLOAT...

To me it sounds like you have an Azure SQL instance, not an Azure SQL Managed Instance.

Did a quick google and found this document from Microsoft:

https://docs.microsoft.com/en-us/azure/azure-sql/database/features-comparison

If you scroll down a...

• This reply was modified 4 years, 2 months ago by Mr. Brian Gale.

The reason it is not implicit is that there is no hard rule saying the default instance must run on port 1433, and most people change it off of the...

I second the "nonwork_days" table, but I would make sure to design the reason code table well.

You would want to make sure that the reason code table has a reason...

Could you post the DDL for the tables?  Mostly, I am wondering what the datatype on "Length" is.  If it is not a numeric data type (numeric, decimal, float, int,...

• This reply was modified 4 years, 2 months ago by Mr. Brian Gale. Reason: adding potential fix

I am not 100% certain on the Access syntax for this, but I see a few potential solutions.

My recommended solution would be to do this as a stored procedure rather...