Unanswered: dynamic column request
I have an ODBC client who sends an insert statement into TABLE1 defined as:
Each EQ, CD, En triplet needs to be stored as a record in a different table. I have an AFTER INSERT trigger on TABLE1 and in it I would like to be able to write a loop to store these records. Using dynamic sql I can create a insert statement like
INSERT INTO table2 (eq, cd, data_point_id, value
VALUES (11, 13, En)
but instead of En I need the value contained in En.
Any one know how to do this? I have tried so many different approaches I am thoroughly confused.
NOTE: Please disregard the label "Senior Member".