Okay, thank you, now I understand what is going on. These values appear to be stored in a database table, which (if so) will make this change easy to do....

Yes, I am right-clicking the dtsx file and opening in Notepad++.

Sorry if I'm not exactly following the rest of your reply. But we have flatfile connections, as well as...

As Sean said, we need to know more about your data before we can give you a good answer. But are you maybe looking for something along these lines?

WITH

CTE...

Here's some SQL2K5-friendly DDL, in case anyone else is stuck in the stone ages like me:

declare @tblA table ( ID int, Value int, primary key ( ID ) )

declare @tblB...

Just want to chime in and say thanks for posting, because I'm currently stuck in this same nightmare and it's taking multiple departments here and a ton of googling and...

That is what they mean by proxy, but I'm just not seeing the RUN AS options when I try to create the SQL Agent job. Must be some permissions issue...

I've spent an insane amount of time on this. I'm sure there's an easy solution.

Apologies again for my ignorance, I'm just not seeing anything obvious here.

They are telling...

This might not be helpful, but you might want to look at some form of caching or a static version of every page on the site. If the issue is...

Also, would this be something you could do with a persisted, computed column instead of a trigger?

I'm still not able to understand what you want to do here.

If you had one record per Calendar_Month, this would make more sense to me. As it is, you...

Instead of passing specific @id numbers to your stored procedure, can you code the stored procedure to automatically find the ID's that need to be merged?

If not, maybe look...

You should make sure your DDL works before you post it here.

You have columns in your table called TRIAL... and in your insert statement called TRAIL...

You have a column...

If you format your code nicely, the answers to questions like these will be a lot more obvious to you and anyone else who has to work on your code...

To further explain things (hopefully correctly), the reason your SQL was failing was that it was determining the MAX value once, and adding 1 to it once, and attempting to...

Thank you, I was wondering why Lynn wrote it that way! Makes sense.