LearnItFirst User Forum

use AR;
go
CREATE FUNCTION EntFunction
(@ItemName varchar(100))
returns @EntTable table (
        EffName varchar(100) NOT NULL,
        EntValue float NOT NULL)
as

BEGIN
DECLARE @TransactionNumber int;
DECLARE @DFreqTable table(
    DName varchar(100) NOT NULL,
    DFreq int NOT NULL);
SELECT @TransactionNumber = (SELECT count(TransactionID) FROM AR.dbo.EffectsTransactions WHERE EffectName=@ItemName)

INSERT INTO @DFreqTable
SELECT
        dr.DName,
        count(dr.DName)/@TransactionNumber AS DFreq
            FROM
                AR.dbo.DTransactions dr, AR.dbo.EffectsTransactions ef

WHERE
        ef.EffectName=@ItemName
        AND dr.TransactionID=ef.TransactionID
GROUP BY dr.DName
INSERT INTO @EntTable
SELECT @ItemName, sum(DFreq*LOG(DFreq)) FROM @DFreqTable
RETURN
END

select EntValue from AR.dbo.EntFunction('ABASIA');

"A domain error occurred."