Okey prieteni am rezolvat puteti inchide acest post

iata rezolvarea

Multumesc celor de la SQL ASK si lui Usman Butt


SET XACT_ABORT, NOCOUNT ON;

BEGIN TRY

BEGIN TRAN

DECLARE @Members TABLE (memb___id VARCHAR(10))


UPDATE MEMB_INFO
SET cspoints = a.cspoints + b.PCPoints
OUTPUT INSERTED.memb___id
INTO @Members
FROM [Character] b
INNER JOIN [MEMB_INFO] a
ON b.AccountID = a.memb___id

UPDATE [Character]
SET PCPoints = 0
WHERE AccountID IN ( SELECT memb___id
FROM @Members AS M )


IF @@TRANCOUNT > 0
COMMIT TRAN
END TRY
BEGIN CATCH

SELECT ERROR_MESSAGE(), ERROR_LINE()
IF @@TRANCOUNT > 0 AND XACT_STATE () <> 0
ROLLBACK TRAN

END CATCH