[legendknight]

Take It Easier

        if(@JobID = '59758') -- 1000 Silk
        begin
        update SRO_VT_ACCOUNT..SK_Silk 
        set silk_own = silk_own +'1000'
        where  JID = (select UserJID from _User where CharID = @CharID) 
        end