You have another way of re-recreate the subscription.

You can create a backUp of the publication database and then restore it at the subscriton database, with this the server will replicate...

Did you try this?

CREATE TABLE #Temp2(PRID INT,LOCID INT,Rev_CatID INT,MSTTYPE CHAR(1),

AGGTracked INT,AGGDE1 INT,AGGDE2 INT,AGGUpdateEntry INT,AGGPagesReviwed INT,AGGSenttoImageReview INT,

AGGReplaced INT,AGGDuplicate INT,AGGReIndexed INT,AGGDeleted INT)

INSERT INTO #Temp2

SELECT PRID,LOCID,Rev_CatID,MSTTYPE,

SUM(CASE WHEN MCMetric ='New'...