Motz (5/4/2013)
Thanks, its working but taking lot of time. I have almost 30000 prj_id's. Any suggestion on how to improve the query performance or any change in query that makes performance better
how much time?
what indexes have you got in place.
The first records set is the table data which is cumulative data, but i need to populate the data for the missing dates as well and insert new record set in another table.
just a thought...but is it necessary to do the cumulative query first?...is it possible that we could wrap this up in one hit?
seems to me that you have transactional data > you are then summarising this into a table> you then want to add missing months and populate another table
what are you intending to do with the resultant table?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day