__>IF
__>((CurrCoef1 >= Coef1 - @Delta) and (CurrCoef1 <= Coef1 + @Delta)) and
__>((CurrCoef2 >= Coef2 - @Delta) and (CurrCoef2 <= Coef2 + @Delta)) and
__>...
__>((CurrCoefN >= CoefN - @Delta) and (CurrCoefN <= CoefN + @Delta))
__>SET @RESULT = 'SPAM'
__>ELSE SET @RESULT = 'NOT SPAM'
__>

select id from CoefLst where 
  Coef1 between @coef1 - @delta and @coef1 + @delta 
AND 
  Coef2 between @coef2 - @delta and @coef2 + @delta 
AND
  Coef3 between @coef3 - @delta and @coef3 + @delta
...

1.1.4 stable rev. 510

select message_id from coef_values where 
(coef_id = @coef_id_1 and coef_value between @coef_1_value-@delta and @coef_1_value+@delta)
 OR 
(coef_id = @coef_id_2 and coef_value between @coef_2_value-@delta and @coef_2_value+@delta)
...

select count(*) as hit_count, message_id
from (/*тут наш селект, приведенный выше*/)
group by message_id

select count(*) as hit_count, message_id
from (select message_id from coef_values where 
(coef_id = @coef_id_1 and coef_value between @coef_1_value-@delta and @coef_1_value+@delta)
 OR 
(coef_id = @coef_id_2 and coef_value between @coef_2_value-@delta and @coef_2_value+@delta)
) hits
group by message_id
having hit_count > @hit_count_threshold

select * from point 
where 
X  between @x_min and @x_max
AND
Y  between @y_min and @y_max
AND
Z  between @z_min and @z_max

select * from point 
where 
(X  between @x_min and @x_max AND Y  between @y_min and @y_max)
OR
(Y  between @y_min and @y_max AND Z  between @z_min and @z_max)
OR
(Z  between @z_min and @z_max AND X  between @x_min and @x_max)

1.1.4 stable rev. 510

CREATE TABLE CoefLst(
[ID] int IDENTITY(1,1) PRIMARY KEY CLUSTERED,
Coef1 float NOT NULL,
Coef2 float NOT NULL,
...
...
CoefN float NOT NULL,
AddDate datetime DEFAULT (getdate()) NOT NULL,
ParentID int NULL

)

IF
((CurrCoef1 >= Coef1 - @Delta) and (CurrCoef1 <= Coef1 + @Delta)) and
((CurrCoef2 >= Coef2 - @Delta) and (CurrCoef2 <= Coef2 + @Delta)) and
...
((CurrCoefN >= CoefN - @Delta) and (CurrCoefN <= CoefN + @Delta))
SET @RESULT = 'SPAM'
ELSE SET @RESULT = 'NOT SPAM'

__>CREATE TABLE CoefLst(
__>[ID] int IDENTITY(1,1) PRIMARY KEY CLUSTERED,
__>Coef1 float NOT NULL,
__>Coef2 float NOT NULL,
__>...
__>...
__>CoefN float NOT NULL,
__>AddDate datetime DEFAULT (getdate()) NOT NULL,
__>ParentID int NULL

__>)
__>

CREATE TRIGGER ins_rec ON [dbo].[CoefLst] FOR INSERT
AS
    DECLARE @Coef1 float
    DECLARE @Coef2 float
    DECLARE @Coef3 float 
    
    DECLARE @id int

    DECLARE @delta float

    --Можно прочитать откуданибудь если хочется
    SET @delta = 0.1    

    DECLARE ins_rec CURSOR FOR SELECT [Coef1], [Coef2], [Coef3], [id] FROM [inserted]

    OPEN ins_rec
    FETCH NEXT FROM ins_rec INTO @Coef1, @Coef2, @Coef3, @id
    WHILE @@FETCH_STATUS = 0
    BEGIN
        IF EXISTS (SELECT [id] FROM CoefLst
        WHERE (@Coef1 BETWEEN ([Coef1] - @delta) AND ([Coef1] + @delta)) AND
              (@Coef2 BETWEEN ([Coef2] - @delta) AND ([Coef2] + @delta)) AND
              (@Coef3 BETWEEN ([Coef3] - @delta) AND ([Coef3] + @delta)) AND
              [id] <> @id --Запись кот. проверяется на спам уже в таблице
                  --Но в случае спама удалится при откате
        )
        BEGIN
            ROLLBACK TRANSACTION
            RAISERROR ('Error: ins_rec Спам', 15, 1)
            RETURN
        END
        FETCH NEXT FROM ins_rec INTO @Coef1, @Coef2, @Coef3, @id
    END
    CLOSE ins_rec
    DEALLOCATE ins_rec
GO

CREATE TABLE CoefLst(
[ID] int IDENTITY(1,1) PRIMARY KEY CLUSTERED,
Coef float NOT NULL,
CoefType int NOT NULL,
AddDate datetime DEFAULT (getdate()) NOT NULL,
ParentID int NULL
)