[TheBold]

تمام جداً
كله شغال زي الفل
ما عدا بعد ما شغلت السكرول التانية
الاولى شغالة لسه لكن التانية ولا بتعمل اي حاجة

if
(@JobID= '33791')
BEGIN
    DECLARE @USERJID int; 
    SET @USERJID = (SELECT USERJID FROM SRO_VT_SHARD.._USER WHERE CHARID = @CHARID); 
    IF (SELECT COUNT(*) FROM SRO_VT_ACCOUNT..SK_SILK WHERE JID = @USERJID) > 0 
        UPDATE SRO_VT_ACCOUNT..SK_SILK SET SILK_OWN = SILK_OWN + 10 WHERE JID = @USERJID;
        UPDATE SRO_VT_ACCOUNT..SK_SILK SET SILK_GIFT = SILK_GIFT + 10 WHERE JID = @USERJID;
END

دي شغالة تمام لحد ناو حتى بعد ما ضفت دي
" مع العلم ان التانية مش شغالة ( عممال اعيد و ازيد انا هههه ) "

if
(@JobID= '33792')
BEGIN
 
    SET @USERJID = (SELECT USERJID FROM SRO_VT_SHARD.._USER WHERE CHARID = @CHARID); 
    IF (SELECT COUNT(*) FROM SRO_VT_ACCOUNT..SK_SILK WHERE JID = @USERJID) > 0 
        UPDATE SRO_VT_ACCOUNT..SK_SILK SET SILK_OWN = SILK_OWN + 100 WHERE JID = @USERJID;
        UPDATE SRO_VT_ACCOUNT..SK_SILK SET SILK_GIFT = SILK_GIFT + 100 WHERE JID = @USERJID;
END