Please try my modified code above, now with your data and added a fix for updating the received amount on Pledge table.

Try this, not sure it handles all of your scenarios, so more sample data would be good. But it is working for what you given us.

declare @Pledge table (acctID int,...

dbaltazar, hope you don't mind us asking all these questions, we are trying to understand.

I also agree with what is being said, it seems like this should be an application...

This is definitely doable. Just few more questions first,

1) do the payment dates always equal to pledge date? Can I pledge today and pay next week? In other words, do...

Sounds like he doesn't. Is it correct that you just apply payments until a pledge is filled and then next payment is toward the next pledge?

Could you have the scenario...

Ok. This seems more of a .Net issue, SqlBulkCopy is a .Net class.

Looking at this link

It seems ColumnMapping only takes real column names, so your syntax of trying to...

Were you able to upload the data before adding this column into your mix? If not, then there is something with your ASP.net code. If yes, then after you add...

Is it possible just to default the column on your table to getdate()?

In SQL Server Management Studio, right click on your table->Design->Click on Column Name->Put getdate() in "Defautl Value or...

1. Like BrainDonor said, you can put this in a stored procedure and have your scheduled task call that stored procedure. Inside the SP, you would select information into a...

You are welcome. This wasn't your homework, is it? 😀

What about the Date that was your original question? I guess you can figure that out on your own.

For these two tables, there are at least these two ways to...

No offense, are you asking how to do a group by?

If so, then I've added another row in the table because all your sample data are unique so group by...

Paul,

I DEFINITELY appreciate your help as well. I guess the other explanations made more sense. I need examples! 😀

Thank you all for your help. This makes sense. I guess I just never looked things up 😀

Also doing only INNER (where you put the predicate didn't make a...

Thanks, that explains case #2 very well. Any suggestions on #3?