Hi please help me in giving Migration scriptMigartion Script for the below requirement1. Create one table having patient_id, first_access_date,last_access_date with data types as varchar,date,date 2. Get all the tables having the patient_id, then do the union query for all the table 3. Using the above query get the min and max for the created_date or modified_date columns with group by patient_id, year of the date field 4. At last populate the newly created table with patient_id, min-> first_access_date and max -> last_access_date
Migartion script required
Posted - 2010-05-21 : 09:43:58
