Aha. That's the piece of...

I'm not following what your question is then. Are you just looking for an example of how to do an insert with Dynamic SQL? Any chance you could...

Is that exact code failing on your server, or is that a representation of what you're trying to do?

That code executes properly on my box. It also executes without the where for all 30,000 lines of my current Tally Table. (Up to year 4508)

You shouldn't need dynamic SQL to accomplish this goal.

Take a look at the following:

INSERT INTO NewTable(A,B,C,D,E,F,G,Total)

SELECT A,B,C,D,E,F,G,SUM(A+C)

FROM OldTable

WHERE B = Something -- Optional Where clause

GROUP BY A,B,C,D,E,F,G

Can you copy the code directly from your stored procedure as you have it and paste it here? I get your expected result when I run my code against...

Your best approach would begin with posting sample table structure / data and showing us what you're trying to do(by posting your code), and explaining why it's not working and...

If you're running that against your "test" data......

Unfortunately, I've hit a dead wall with the method I...

Have you tried Lynn's solution?

At this point it would help to have some DDL and sample data for these tables. We are only going to be able to throw theory / keywords at...

Sorry for not getting back with you Dan. Lost the primary hard drive in my dev machine yesterday, so it was an all day affair getting the thing back...

I went back and forth on even posting this as is, but maybe it will help you. This solution would build an all encompassing table that covered all currency...

This is how I normally do it. I would probably do some additional checks on the data before performing a delete of this nature, but the concept is the...

Gonna need more information.

How much data is "very large amount of data"? How many rows in each of the 4 tables you are working with?

How long is "sholdnt take...