I need to be able update all the rows in Table using information from another Table and a Formula.
EG:
Table #1 (Only has ONE Record)
GoodMails (Int)
BadMails (Int)
Table #2
Tokens (String)
GoodTokens (Int)
BadTokens (Int)
Score (Numeric(18,4)
I only want to read Table 1 ONCE
I then need to...
My Spam Filter is working great using Bayesian Filters and for those of you who want to know how Bayesian Values are calculated the following procedure should explain it. Anyway on with my problem. I want parse ALL the Tokens that I have collected when I process the Email to a Stored Procedure...
I have this strange problem where a Calculation in my Stored Procedure only shows the Int Value. The Code below always returns 0 or 1 and never the decimal value. Can some on help?
DECLARE @HAMS int,
@SPAMS int,
@GOOD int,
@BAD int,
@SCORE decimal(14,3)
SET @HAMS = (SELECT...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.