That I do not think that should be the problem as when I run it manually it runs fine.

I think DTS should work fine with this... I have done something like this earlier and I used DTS with different compare and update sql scripts... Good luck!

Thanks Jasper... I think we are close but this query is not doing the job. But I can work from it... Big help! Thanks.

Thanks Jasper This seems like does the rite thing... I am sorry I am a new developer therefore I need help. This query I think pulls for the entire contribution1...

Jasper Thanks for your help.... I did not realize earlier it was you who replied.

This is the query I got for Month = January 2006... Now how can I use your last query. please suggest Ray. Thanks again for your big time help.

select Ind_id...

I mean anyone... thanks

No one please

What if the month and years are spread to 10 years? Do we have to write bunch of Case statements or there is way to calculate alternates for any length...

Thanks a lot Ray. It works for sure.

Thanks for the help.

The contribution table as contrib_id (primary key, individual_ID, date, amount...etc.

contrib_id   ind_id amount  date

1238          5562   20.05   12/03/2005

1299          5569    10.25   01/05/2006

1310          5562    20.25   01/05/2006

So one ind_id can be in every month or...

create a table with pre-determined columns and then do the transformation... still you have go through every connection and do the transformation according to the files....

I don't see the way...

thanks all I got it

thanks all I got it...

there is one way... look for his number and call him...

sorry