October 2nd, 2000, 06:06 PM
Join Date: Sep 2000
Time spent in forums: < 1 sec
Reputation Power: 0
The problem I am having is that the information in the database is sent to me in 70 character limits for the product description. Some skus have 75 rows in its description. I want to select every row with the same sku order it by the 2nd field which is the line number. Then take the third field which is the product description and place that in another table.
I want to make a new table with fewer rows.
This is the way it is now:
old_table over 3,000,000 rows
<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">code:</font><HR><pre>
sku linenumber desription
00001 1 this line in carried to the next row
00001 2 this one to the next row
00001 3 Last line of this description
00004 1 this is new
00004 2 this is second new
00004 3 this is last new
This is what I want:
new_table less than 70,000 rows
I need the data from column 1 and 3 to look like this
So from the table above I need rows 1 to 3 in row 1 below
and 4 to 6 in row 2 below.
00001 this line in carried to the next row<br>this one to the next row<br>Last line of this description
00004 this is new<br>this is second new<br>this is lastnew
[This message has been edited by Masters (edited October 02, 2000).]