Not sure if I'm helping or not, but I know where I work, we have a separate job for cleaning up the history.  My preference is to have a maintenance...

OH... you could likely sum it over a partition then, no?
It is the t.MktDiff column that you are trying to sum up... what if you change the line:

Do all of your parameters need to be unique?  That is, is could you reduce the number of parameters by reusing some?

If not, could update the parameters as...

Can you post DDL and sample data for TRValue and TRProp?
We'll need more info in order to help.  But best guess is that it isn't actually skipping it, it...

I'm sure there are some free tools, but I recommend RedGate's SQL Compare for that task.

I used it when we were upgrading a system recently and found it...

My personal preference is to not fill the disk.  Start the database out at a reasonable size.
Filling the disk means you may get a surprise one day when it...

I think (but can't be sure without seeing the data) is that you'd want to add an extra clause to your WHERE in the nested selects.  You would want to...

To me, your solution sounds more like a workaround to me.  Or did running that once fix the log growth issue?

I'm just thinking that to me, your solution...

Depending on how they need to share the data, you could have a new database per city.
likely not an ideal solution, but it is another option.

a new...

If you have an MSDN license, you could just spin up a windows 7 VM for testing it.  Since you didn't use WPF, I can't think why it wouldn't work...

Was just looking at the application and I am a little confused about it.  

At the moment, I am not sure how this is much different than just...

Can we get some DDL and sample data to work with?
The way that that is now, I don't understand what the data looks like nor why you'd need a...

We actually have that set up where I work.  Although we use a 3rd party tool called DxEnterprise (I do not work for them).  If you have used Polyserve before,...