I just picked Movie and was told I was wrong.  Cut and pasted the code to SSMS and ran it with Movie for the order by and got Ebenezer Scrooge.

I haven't used Data Masker.  As you are having different results on different, but identical tables, that tells me at least that it isn't Data Masker but something different between...

One, the applications aren't certified by third party providers for the latest version of SQL Server and licensing requirements require running approved versions of SQL Server.
Two, cost of upgrade...

The only time I have seen two identical tables behave differently came down to the fact the data was not stored identical between the two tables.  The data distribution was...

So, is this what you are looking for?

IF OBJECT_ID('dbo.TestTable','U') IS NOT NULL
  DROP TABLE [dbo].[TestTable];

CREATE TABLE [dbo].[TestTable](
  [name] VARCHAR(30)
  , [ShiftType] VARCHAR(30)
 ...

Thank you!

So is it too soon to start planning for next year?  I may not watch any football but I enjoy the SSCFFL.

So, are you looking for something like this?

IF OBJECT_ID('dbo.GroupMembers', 'U') IS NOT NULL DROP TABLE dbo.GroupMembers;

CREATE TABLE dbo.GroupMembers
(
    GroupCode VARCHAR(1) NOT NULL,
   ...

Time to Party Hardy!  What a way to end the season!

Merry Christmas to one and all.