Should your example case statement end in ELSE 3ltrcode END instead of ELSE END? I assume you actually want to join on a3ltr code except for these/similar translations.

Comments is dependent...

a) Putting T-SQL code in a code block

b) Providing data in a consumable format (which can be pasted into SSMS)

This just means (again using code sample control)...

It sounds like you might be looking for Reporting Services data processing extensions, if you're trying to mediate/alter the source data outside of SQL Server or other RDBMS.

The missing index recommendation looks pretty good in this case -- you have a table scan because you are joining on PartLevel, but have no index.

Thank you for providing DDL...

I'd love to see a generic framework/example for this, even if the OP has left the building.

I know your preference for datetime over datetime2, but would also be interested in...

Not automatically. You could view object details right click to generate alter scripts (or create & then replace "CREATE VIEW" with "ALTER VIEW"), and then just do find-and-replace.

Easy if everything...

One would hope response time wouldn't change... though I've seen companies where even that might not be true.

I could see resolution time changing (e.g., help desk declares it resolved, user...

Yes. MS SQL Server uses identity, not auto_increment, which appears to be a mysql construct.

In MSSQL, I tend to prefer using sequence over identity (which now actually uses sequence...

Do/can your last names include any hyphenated names? Do you have any cases where you also have middle names (or two part last names with spaces)?

If not, CHARINDEX & SUBSTRING...

You indicated you split a table into two tables, but showed the DDL for only one table. Is this the before or after?  If after, what's the second table?

What are...

Every CPU these days is multi-core. Obviously, faster clock speeds is generally better than slower for similar core counts.  Look at https://www.cpubenchmark.net/ for CPU ratings & comparisons, including performance/price ratios.

Glen...

What should room_type be if it's a tie (50/50)?

What do you mean by "re-allocate the files"? Changing the name?

You haven't shown the other pages. Did you change the Database name on the first (General) page? That is what...

Yes it's possible. You can see if this thread helps.

For the purposes of the .Net tutorial, it seems like authentication type should be irrelevant.

I agree w/ Mr. Gale that using prefix "vw" for views and "trg" for triggers is a good, common, reasonable exception to the "don't prefix w/ object type" rule. And...