How to Convert This Algorithm to Microsoft SQL Server 2005 Stored Procedure

See more:

SQL-Server-2005

SQL-Server

Algorithm 2 (table FP construction)
Input: a transferred transaction table T 0
Output: a table FP
Procedure:
for items with the rst identical tid in the table T 0
insert into the table FP
for items with the other identical tids in the table T 0
insertFP (items);
insertFP (items)
count := 1;
curpath := null;
if FP has an item f = i1 (the rst item in the items) and f: path = null
for each item ik in the items
insert ik into the table FP;
curpath += ik;
else
for each item ik in the items
if FP has not an item f = ik
insert ik into the table FP;
else
if f: path != ik: path
insert ik into the table FP;
else
curcount = ik: count + 1;
update the table FP;
curpath += ik;