You have an adjacency list model. If there are not too many levels of hierarchy, querying can be handled via CTE. But you might want to consider nested sets:

• https://explainextended.com/2009/09/25/adjacency-list-vs-nested-sets-sql-server/

...

You've practically written simple list already:

SELECT cus_no, address, city, state, zip
FROM table 
WHERE cus_no IN (cus1, cus2, cus3)

Since you're not on SQL 2017+, STRING_AGG() function  isn't available if...

My experience in the past was that many email clients didn't handle CSS well, & I ended up needing to rely on tables & HTML formatting tags rather than CSS...

https://cloud.google.com/sql/docs/sqlserver/upgrade-major-db-version-inplace

You said "they will later export to a production database in the same server". Are you saying they will export tables in their own schema to their own schema in...

This will get you the first day of the current year:

DECLARE @StartDate DATE = DATEADD(year, DATEDIFF(year, 0, GETDATE()), 0);

Do you want only completed months, or everything through...

Removing the table article from the distribution and then re-adding would allow it to re-synch (assuming it drops/deletes/truncates & recreates).  You said you don't even have permission to view replication,...

You can definitely do that. What are the roles of these users? What are the uses of the tables they would create? Do they really need their own permanent tables,...

You might be able to resolve the problem, but need to make absolutely sure that you re-insert only the rows that you deleted, and not any new rows, or you...

The GetTheStanine procedure you posted is not setting a return value, it is doing a select. How are you not just getting zero from these calls?

EXEC @Energy...

Sorry... Didn't notice it before. The syntax to set a variable equal to the return code of a proc is

EXEC @Energy  = GetTheStanine @AppID,1,8; 
EXEC @Flex...

What is your definition of duplicates in this scenario? Please provide an actual example of multiple rows that comprise a duplicate (obfuscated if necessary).

There should be only one row for...

What is "a standard nine value"?

You didn't provide code for GetTheStanine. Does the GetTheStanine procedure return (not select) an integer value that you want in @Energy, @Flex, @Develop, & @Distort?...

Is the query optimized? Do you have the necessary indexes? If you provide DDL for the tables & views involved, the proc logic, & execution plan (obfuscate if needed to...

Why do you want to use such a non-standard format instead of just a standard CSV with column names in a header row? Or no header row if the data...