i have 2 tables; the first one records information about shapes. this table has 3 fields where the primary key is a composite one with the shapeID and DimensionName.
one shape has 3 records in this table since there can only be 3 values as DimensionName for a given shape (weight, price and color)
the second table has the shape ID , weight, price and color as its columns. where the shapeID is the primary key.
now what i need to do is i need to map the first table's 3 columns in to 1 column of the second table. i am allowed to use cursors for this.
can anyone please explain how can a approach thisproblem?? code snippets are warmly welcomed. :)
please referr the image for further clarification. to view the image, click this link http://i53.tinypic.com/2rcal2x.png
thanks in advance
View Complete Post