asked
Inserting into table from another table for dynamic columns
Hi.. I have a table(say **Table1**) like this... ![alt text][1] And I have a procedure(with no_of_columns as parameters) that creates a table(say **table2**) with dynamic columns.. but for table2 first five columns are same as first five columns of table1 .. and for remaining (dynamic) columns i need to insert values as 0 (zero).. output format is as below image... ![alt text][2] any IDEA ???????? [1]: /storage/temp/1429-emails.jpg [2]: /storage/temp/1430-dtable.jpg
Hi, Can't you just set the default value for the "dynamic" columns to zero, when you create the second table ? Ian.
15 People are following this question.
