Thanks for the response.

Each task is successfully completed.  File is begin grabbed from the FTP server and transferred to the destination folder. I can see the file being populated and transferred.  Then it gets...

Thank you

This statement will not work for dates that fall in the year 2000. Which is the best way to do for year 2000?

Thank you very much for your help.

I tried to go couple grouping in the where clause, but for some reason the results were not as expected and the date span...

Table structure

Create Table #FB_Totals (Year char(4),Client# varchar(6),Invoice varchar(20),Jan dec(9,2),Feb dec(9,2),Mar dec(9,2),Apr dec(9,2),May dec(9,2),Jun dec(9,2),Jul dec(9,2),Aug dec(9,2),Sep dec(9,2),Oct dec(9,2),Nov dec(9,2),

Dec dec(9,2))

Output should be as follows for TotalDays

2002,123456,Days,15 , 28, 9, 0,0,0,0,0,0,0,0,0

Output...