Re-visiting this thread, based upon doing some more evaluating of various hardware and VM's

How many SCSI controllers are configured in this machine?  And, what type are they?
We...

What do you need to do?  

If you want a stand-by copy of the database for DR, and are using log shipping, then the database will indeed be...

No.  Changing the data on the subscriber is not an uncommon requirement.
The issues you may face would be that transactions from the publisher would fail.  Identity fields are good...

Without the actual schema, and some sample data, it's a bit difficult to figure out exactly what may be going on.

I created a single column table with a...

SELECT DISTINCT *
INTO #TempTable
FROM OriginalTable

TRUNCATE OriginalTable

INSERT INTO OriginalTable
SELECT * FROM #TempTable

Not knowing the structure of the table, but you may need...

Well, that seems to have done the trick.  Thanks!
As soon as I read it, I realized that I never added this to the GPO.

I'm curious about the time it take for the query to complete if it is run in SQL Management Studio.  I think the place to start is to make sure...

Do you understand why it worked? And why Luis's code worked and mine didn't?

You do not need a temp table.

This should work

CREATE VIEW dbo.YourViewName
WITH SCHEMABINDING
AS

    SELECT issue_number,
        type_code,
        CASE
            WHEN alt_type_code...