Since the second table is somehow only temporary table (having at the front ajax script), i need the third table to store user's ID and all the info from second table.
What would be the easiest way to do it, since the first table contains only one row per user and the second one 40 rows per user.
No idea what you mean but insert table3 select t1.Userid, t2.set, t2.item, t2.Order from table1 t1 cross join table2 t2 where t1.Userid = @myuserid
========================================== Cursors are useful if you don't know sql. DTS can be used in a similar way. Beer is not cold and it isn't fizzy.
The main problem i have is that all data are written in db dynamicly and what i need is to have a third table to preserve/save all corresponding data from table 1 and table 2.
temporary table
Posted - 07/29/2007 : 18:41:55
