Thanks for replying....thats the point I am stuck at. Well I wonder, Let me re-collect what you just said is...like first i have to hard code the SQL (select statement...

Well.....I did not tested the earlier code into the prod db yet....but for test db with like some 25000 records, the earlier code took roughly around 1 second, but the...

Thanks you Guys.......That Works pretty Great....with a significant improvement......

Thanks Craig...for your input. Well, I checked this and just wanted to discuss...basically the query u gave gives the month end records and what i need basically are the records...

Raunak

Thanks for the help, but can u please explain a bit more on the later part you mentioned about when having

" If you have many distinct ID's in...

How about putting those packages in a single master package by using execute package task and then deploy that single master package...will that work

Thanks for showing up your interest.

Corrupted ...here in the sense could be - say..dimension tables got deleted or something else...just corrupted And we do not have backup for them.....basicallly i...