It would work in case you have data for one month. If you have data for multiple months, I think you need to do it as follows:

SELECT MAX(I), MIN(I), k...

I think the same could be done using trigger on insert on said table @t. Within the trigger, you may please use the following to return all the identity values:

select...

if anybody is interested to take it up, I can send you a test database dump. please contact me at amit@ontrackindia.com or amit_khan77@yahoo.com

Regards,

Amit Khan

Ontrack Systems Limited

276B Lake Gardens

Kolkata - 700045

India

Phone...