Macth log ERROR

[Tiago Pedro]

does anyone know why this happens?

 

[davilopes]

Ranking update, build the sp.updategunzsystem

 

[Tiago Pedro]

do you have the query?

 

[jorklenis2]

USE [MiDB]
GO
/****** Object:  StoredProcedure [dbo].[spUpdateGunzSystem]    Script Date: 3/18/2021 6:23:57 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROC [dbo].[spUpdateGunzSystem]
AS
BEGIN	
	SET NOCOUNT ON;
	
	/* Delete ClanMember where DeleteFlag = 2 */
	DELETE FROM ClanMember WHERE CLID=(SELECT CLID FROM Clan WHERE DeleteFlag=2);

	/* Update Clan where DeleteFlag = 2 */
	UPDATE Clan SET Name=NULL, DeleteFlag=1, DeleteName=Name WHERE DeleteFlag=2;

	/* Update Character Ranking */
	EXECUTE spFetchTotalRanking;

	/* Update DTTime Stamp¦ */
	IF NOT EXISTS(SELECT * FROM DTTimeStamp WHERE TimeStamp=(CONVERT( CHAR(8), GETDATE(), 112))) BEGIN
	    EXECUTE spDTInsertDTTimeStamp 0;
	END
	EXECUTE spDTFetchDTRanking;

END