To emphasize what Sue_H said, check the logs.

Without error messages it is impossible to say what is wrong.

And to reiterate what Sue_H said, "Shared Features" are features that are shared...

Kind of, but SQL is a little bit different than the images you sent (that look like Excel?).

SQL has all of the data in the database and is just holding...

I would recommend looking into Truth Tables.  But basically, what the approach is doing is if condition1 AND condition2 are both TRUE, then use the first option.  If EITHER condition...

I think that is possible, but not QUITE the way you wrote it.  What I think you would need to do (I don't have your data or any DDL to...

Kind of.  Anything that needs to authenticate as that account will fail.  Anything that has previously authenticated will work fine.  SO, the SQL instance will continue to run without problems,...

I sometimes do use the table name as the alias.  The reason I do this is that SQL Prompt SQL Format will automatically add the alias onto my columns IF...

Two thoughts.  First, does:

EXEC SP_who2

give you any results for a user connected to the database test1?  If there are a lot of connections, it can be a...

Happy to help.

I didn't cover EVERY scenario, I just covered some.  For example, if you have an IP allowed list and ONLY a small set of IP addresses are allowed...

The actual rule we have in place isn't specific to single character aliases though.  Our rule is that aliases and variable names must be specific enough to identify the object....

Since you have all the hard work done, all that's left is to put the table names in and define how you want to join them.  Since you have a...

I think this post will tell you how to do it:

https://stackoverflow.com/questions/49741600/database-stuck-in-a-single-user-mode-in-sql-server

To paraphrase, run

SELECT spid
FROM master..sysprocesses 
WHERE spid > 50 AND dbid = DB_ID('<Your_DB_Name>')

and kill that SPID.

To add to what Pietlinden said, we also have no visibility into that function.  You MAY be able to tune the function.

As far as I know, using a table valued...

I am not sure why you marked the previous answer as spam when it (as you said) answered your "initial question" but was not what you were expecting.

If you followed...

I'd probably start by writing it in a manner that is easier to see and read (my preference, not required).  So something like:

  WHERE 
 ...

If the database names and table names are static and not going to change (ie no new ones coming in and none going away), then I'd recommend hard-coding it all...