Tenta adicionar esse código após o @Value de cada tipo de moeda.
JOIN dbo.MEMB_STAT ON dbo.MEMB_STAT.memb___id = dbo.CashShopData.[AccountID]
WHERE dbo.MEMB_STAT.ConnectStat = 1
Ficando assim, no caso de WCoin
-- Tipo 1: Update Cash | Wcoin
IF @Type = 1
BEGIN
UPDATE CashShopData SET WCoinC = WCoinC + @Value
JOIN dbo.MEMB_STAT ON dbo.MEMB_STAT.memb___id = dbo.MEMB_INFO.[AccountID]
WHERE dbo.MEMB_STAT.ConnectStat = 1
--Para Season 4
--UPDATE MEMB_INFO SET Cash = Cash + @Value
END
tentei, me deu esse erro
Msg 156, Level 15, State 1, Procedure WZ_SetRewardAll, Line 19
Incorrect syntax near the keyword 'JOIN'.