hello everyone,
this is part of the algorithm that i need to code using MS SQL
k = 1
C1 = generate counts from R1
repeat
k = k + 1
INSERT INTO R!k
SELECT p.Id, p.Item1, …, p.Itemk-1, q.Item
FROM Rk-1 AS p, TransactionTable as q
WHERE q.Id = p.Id AND
q.Item > p.Itemk-1
.
.
until Rk = {}
so i...