Seems to me like you only need on person table where you keep both parents and child in it.

But then again I don't have enough info to really guide you...

That's a long shot, but any chance that you have both execution plans?

Do you have blocking issues?

Do you have a big job running on the server that could eat up...

SELECT SUM(Tally) FROM dbo.TallyMarketing

I'm not too sure what you want to do next though...

BTW my first instinct is to tell you that such calculations are often better left off to...

Post the code and sample data so we don't have to guess at this problem.

Ah, now that makes sens!

Thanks 😀

I'm not sure I'm following here Jack, can you explain a little bit more?

I built something like this once... took me a month (was in a bigger project).

If I were you I would not waste time on this matter. SSMS is the...

Lol, ya I forgot about that one... hoping that didn't screw up anything with the application. Only time will tell.

That actually might work in your favor if it did...

1st of all, autp update is triggered after a huge % of the data has been changed (5% or 20%)... not before that... so you have 1M rows, you need...

No they won't. You need to pick out the order so that the first column is the most granular... or makes the most sens for order bys.

In the case...

Maybe it's just me, but I was under the impression that SSN is not unique across the planet... that's why you need to have another column such as CountryId to...

It is. If you scan only syscomments, it means that 100% of the data access is done via stored procs or other sql objects.

Since it wasn't the case for...

I'd love to hear their reasons for wanting this... then I'd also love to have them read those forums!

I know... but it beats the hell out of adding 50 commas manually!!!

Anyhow, I still preffer the scripting option of the GUI.

Ya sorry about the "bad" news.

A little word of advice, if you are not forseeing any problems (performance, db size, etc.)... your time might be better invested elsewhere. Over...