I would be grateful for any help in the following:
1. I need to create additional records (probably using INSERT command) within a SELECT statement depending on a particular condition / situation. I normally use CASE statements within a SELECT statement to handle different conditions. The newly created record will be populated with a combination of literal values and the values from other fields of the first record.
2. I need to create one record from a set of records. The scenario is, we store all the changes, made to any table, on a particuler day in the audit trail table. The table is will store the ,Key field of the master table, field name, type of change (Add, Edit or Delete), Old value and New value of this field in one record. Separate records will show the different field name of any master table. I need to bring all the rows (records) belong to any key field (i.e. one row in the master table) into one row, showin the old & new values of all the fields on one single row.
I hope this explains.
I would appreciate if someone could help me to solve these problems.
Sivi
1. I need to create additional records (probably using INSERT command) within a SELECT statement depending on a particular condition / situation. I normally use CASE statements within a SELECT statement to handle different conditions. The newly created record will be populated with a combination of literal values and the values from other fields of the first record.
2. I need to create one record from a set of records. The scenario is, we store all the changes, made to any table, on a particuler day in the audit trail table. The table is will store the ,Key field of the master table, field name, type of change (Add, Edit or Delete), Old value and New value of this field in one record. Separate records will show the different field name of any master table. I need to bring all the rows (records) belong to any key field (i.e. one row in the master table) into one row, showin the old & new values of all the fields on one single row.
I hope this explains.
I would appreciate if someone could help me to solve these problems.
Sivi