thanks for the reply

I know about the tools

but my question is how to plan.

as mentioned one table in access is divided into 2 tables in sql server.

what i want...

I am sorry...

I was confused and posted at both places....

Application uses both..some places it has dynamic SQL and some places we are using stored Procedures..

Yes i do have the copy of the Production database on the test environment..

If i...

There might be more then 2 or more treatments for the patient... and Treatment ID is a primary key..

That was a really awesome solution Abhijeet. it worked great.

Thanks a lot for your help Sir...it saved my couple hours

Thanks all for the quick response....

thanks a lot Dan

Yes this is a part of ETL Process

I will be updating just one staging table. with the help of 15 main tables..

and this is a daily process and i need...

Sir sorry for the Confusion..I have posted the test data...

Please let me know if you need any more Information

Sample Data

Table ABC

A LastExecutedDate

1 06/03/2010

Table XYZ

T U ...

There is no relation ship between both tables.. just the date is stored in the the ABC table...

Thanks for the Reply

User has only db_owner permissions ...no permissions are given on the Server Role...