create table

  1. J

    Question increment number of fields in MSSQL

    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...