Well, yes. Further, I have completely rebuilt the table, and dropped the original, yet the data...

Well - I sure feel silly. I thought all these replies (above) were going to reference the original posters. Sadly, I am a bit new to posting here. I apologize...

@gilamonster - Interesting idea - I never thought of a calculate combined column! Thanks. I will review this idea with the team.

Thanks, Grant - but, we are using bigints, and the question is really about whether or not to use clustered indexing - not data type.

@ Luis Cazares - Sorry if I confused anyone - we are using bigints. We did discuss three separate keys, and maybe this is the right way. We avoided it...

@gilamonster - Well - we are certainly not doing millions per second. But surely tens or hundreds per second. Finding the breaking point will certainly be possible with...

@gilamonster - I have to use bigint because of the way the keys are constructed, as I mentioned in the post. If I used ints, I would only...

g.britton - thanks very much for your views. I am using bigint. (Actually I'm forced to use numeric(17, 0) because our FoxPro clients don't understand bigints). I am pretty sure...

Jeffrey, Grant, John - thanks for your responses.

I've made some typos in translating this from the real situation to a more easily postable question, and messed up some field names....

The CROSS JOIN is necessary to get a record for every day. So - say for instance you had an IMAX show for next Monday, but hadn't sold any tickets...

Well, it turns out that I made a mistake. NOT FOR REPLICATION was missing fro my trigger. I apologize for the error.

After properly adding it back in, the Init From...

Andy,

Thanks for your time posting this article. I totally love this method - but I have some concerns ...

Doesn't this method have issues if the database being replicated contains triggers...