I guess I needed to add more records to the insert to really see the result. I need more than one record to roll up.

Still not working

Thanks. If any of you get stuck with C# I can help out. 🙂

Thanks, I will bang away on my SP and see if I can't make it more set friendly.

Thanks.

I am much more inclined to the 'Show me the path and let me figure it out' method. So fire away.

I guess to be frank, I am a newbie and don't really know any better. I have learned this all by myself so it is the best I can...

**Many explatives**

It seems like I had a data problem, program testing probably. Deleted everything and inserted from my post inserts and it is working.

Thanks I would have spent days...

Yes that is what I would expect as well but when I do that I get the following error.

Msg 8120, Level 16, State 1, Line 34

Column 'Punch.TimeEntryID' is invalid in...

All Fixed.

Ahhh, I just added the subesquent data rows. I guess my assumption was a little of cut and paste action. I can fix it?

Consecutive <= less than 7 days apart

Not sure what you are talking about. I am using 2005 not 2008 SQL Server.

No, Part 2 has 3 absences but they are not consecutive.

I should see the rows from Part 1 as the exact output.

All Fixed. Sorry and here you go.

INSERT INTO [ClientManager].[dbo].[Fees]

([FeeDesc],[FeeAmount])

VALUES

...

Have you installed MDAC or the OLEDB provider on your server/workstation?

Thank you very much that was exactly what I needed to fix it up. You rock